IntermediateLogical Functions
Flag accounts for review with AND and OR
Combine two logical tests so one condition can override the other.
AND · OR · IF
9 min30 points
Flag orders needing special handling with OR
The situation
The warehouse wants a single column telling pickers which orders leave the normal flow. An order needs special handling if it is a rush job or if it contains fragile stock — either one on its own is enough.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order | Service | Fragile | Handling | |
| 2 | SO-5201 | Rush | No | ||
| 3 | SO-5202 | Standard | No | ||
| 4 | SO-5203 | Standard | Yes | ||
| 5 | SO-5204 | Rush | Yes | ||
| 6 | SO-5205 | Standard | No | ||
| 7 | SO-5206 | Standard | Yes | ||
| 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 reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 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