A condition that changes the rate
Multiply by the result of an IF to switch a premium on and off.
Task:
Shift pay is hours × the hourly rate in B1, with weekend shifts paid at time and a half. In D4:D9 give each shift's pay.
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of Logical Functions with Mathematics
0/4The same formula in the other shapes it takes at work.
- Logical Functions with Mathematics
A threshold that is itself a calculation, not a fixed number.
CoreAdvanced - Pay only on the amount above target
MAX(0, …) turns "only if positive" into arithmetic.
Intermediate - A condition that changes the rate
Multiply by the result of an IF to switch a premium on and off.
Intermediate - Progressive bands with MIN and MAX
Each slice of the amount is charged at its own rate.
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Hourly rate | 14 | ||
| 2 | ||||
| 3 | Shift | Hours | Day type | Pay |
| 4 | Mon | 8 | Weekday | |
| 5 | Tue | 6 | Weekday | |
| 6 | Sat | 8 | Weekend | |
| 7 | Sun | 5 | Weekend | |
| 8 | Wed | 7.5 | Weekday | |
| 9 | Thu | 4 | Weekday |
What this exercise teachesMay contain the answer
Putting the IF around only the part that changes — the multiplier — keeps the pay calculation written once. Wrapping the whole thing (IF(weekend, B4*$B$1*1.5, B4*$B$1)) duplicates it, and the two copies can drift when the rate cell moves.