IntermediateLogical Functions
Apply commission tiers with IFS
Return the right rate from several tiers without nesting.
IFS
10 min25 points
Band orders by size with nested IF
The situation
Harbor Supply wants orders bucketed as Small, Medium or Large for a distribution chart in the board pack.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order | Value | Size band | ||
| 2 | ORD-1042 | $3,400 | |||
| 3 | ORD-1044 | $2,100 | |||
| 4 | ORD-1043 | $890 | |||
| 5 | ORD-1046 | $4,250 | |||
| 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
- IntermediateLogical Functions
Apply commission tiers with IFS
Return the right rate from several tiers without nesting.
IFS
10 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 - IntermediateLogical Functions
Approve orders with AND
Require two conditions to be true at once.
IF · AND
8 min25 points