DECISIONS & ERROR HANDLING · ORIGINAL EXERCISE
Hit the target
For Ari on row 2, return "Met" when hours C2 are at least target E2; otherwise return "Below".
This quest practices Comparison operators using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| Name | Team | Hours | Hourly rate | Target hours |
|---|---|---|---|---|
| Ari | Support | 38 | 24 | 40 |
| Bea | Sales | 42 | 30 | 40 |
| Cam | Support | 35 | 26 | 40 |
| Dev | Sales | 40 | 32 | 40 |
| Em | Ops | 28 | 28 | 32 |
| Fox | Ops | 32 | 25 | 32 |
Hints to get you started
- At least means >=.
- Compare C2 with E2.
- Use IF with "Met" and "Below" as the two outcomes.
Show the worked solution
=IF(C2>=E2,"Met","Below")The >= comparison includes values equal to the target.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →