DECISIONS & ERROR HANDLING · ORIGINAL EXERCISE
Overtime decision
For Bea on row 3, return hours above 40 when C3>40; otherwise return 0.
This quest practices Calculated IF results 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
- The true result can itself be a calculation.
- Subtract 40 from hours if the threshold is exceeded.
- Use 0 for the false result.
Show the worked solution
=IF(C3>40,C3-40,0)IF can return calculated numbers, not just labels.
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 →