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 accounts for review with AND and OR
The situation
Credit control reviews an account when it owes a lot and has been overdue a while — both together, not either alone. But a disputed account always goes to review no matter the balance, because someone has to call the customer.
A1
fx
| Row number | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Account | Balance | Days overdue | Status | Action | |
| 2 | Dockside Hardware | $12,500 | 45.00 | Current | ||
| 3 | Fenwick Building | $3,200 | 60.00 | Current | ||
| 4 | Alder & Vance | $18,400 | 12.00 | Current | ||
| 5 | Riverbend Trade | $1,450 | 8.00 | Disputed | ||
| 6 | Kemper Outfitters | $22,000 | 90.00 | Current | ||
| 7 | Halloway Supply | $780 | 15.00 | Current | ||
| 8 |
Functions in this exercise
Who this is for
Recommended next
Related exercises
- IntermediateLogical Functions
Approve orders with AND
Require two conditions to be true at once.
IF · AND
8 min25 points - BeginnerLogical Functions
Flag orders needing special handling with OR
Mark an order when either of two independent conditions is true.
OR · IF
5 min15 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