IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points
Approve orders with AND
The situation
Harbor Supply auto-approves an order only when the customer has credit available and the order is under $5,000. Anything else goes to a manager.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order | Value | Credit | Decision | |
| 2 | ORD-1042 | $3,400 | OK | ||
| 3 | ORD-1046 | $4,250 | Hold | ||
| 4 | ORD-1050 | $6,200 | OK | ||
| 5 | ORD-1051 | $980 | OK | ||
| 6 |
Functions in this exercise
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
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