AdvancedLogical Functions
Fix a broken commission formula
Diagnose and correct a formula that returns the wrong answer.
IF
14 min40 points
Apply commission tiers with IFS
The situation
Harbor Supply pays a tiered commission: 6% above $120k, 5% above $100k, 4% above $80k, and 3% below that. Payroll needs each rep's rate.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Rep | Sales | Rate | ||
| 2 | Dana Whitfield | $143,000 | |||
| 3 | Marcus Bell | $95,000 | |||
| 4 | Alan Reyes | $78,000 | |||
| 5 | Priya Raman | $118,000 | |||
| 6 |
Functions in this exercise
- IFS — Checks several conditions in order and returns the first match.
Who this is for
Recommended next
Related exercises
- IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points - IntermediateLogical Functions
Approve orders with AND
Require two conditions to be true at once.
IF · AND
8 min25 points - BeginnerLogical Functions
Flag reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 points