IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points
Flag reps below target with IF
The situation
Rather than reading percentages, Harbor Supply's sales director wants a plain label so the underperformers are obvious at a glance in the review deck.
A1
fx
| Row number | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Rep | Sales | Target | Achievement | Status | |
| 2 | Dana Whitfield | $120,000 | $100,000 | 120% | ||
| 3 | Marcus Bell | $95,000 | $100,000 | 95% | ||
| 4 | Alan Reyes | $80,000 | $100,000 | 80% | ||
| 5 | Priya Raman | $143,000 | $130,000 | 110% | ||
| 6 |
Functions in this exercise
- IF — Returns one value when a test is true and another when it is false.
Who this is for
Recommended next
Related exercises
- BeginnerFormulas
Calculate achievement against target
Divide actual sales by target to get an achievement percentage.
3 min10 points - 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