Practice challenge
Flag overtime hours
#11
3 attempts remaining
IntermediateEmployee hoursTarget D2
A timesheet should flag employees who worked more than 40 hours and have approval.
Write a formula for D2 that returns "Pay overtime" only when hours are over 40 and approved is Yes; otherwise "Standard".
Flag overtime hours
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Employee | Hours | Approved | Payroll status |
| 2 | Nora | 43 | Yes | blank |
| 3 | Omar | 39 | Yes | blank |
| 4 | Iris | 45 | No | blank |
| 5 | Leo | 41 | Yes | blank |