Level 2LogicPractice, 2 min
IF: hit or miss
The task
In D2, show Hit if Theo's sales (C2) are at or above his quota (B2), otherwise Miss.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Rep | Quota | Sales | Result |
| 2 | Theo | $45,000 | $45,000 | |
| 3 | Maya | $50,000 | $52,300 | |
| 4 | Priya | $40,000 | $37,850 |