Logical Functions
Advanced
Capstone: triage this morning's orders
Two decisions per row, from the whole logic track.
Task:
Warehouse needs to know what ships today and why anything that does not is held up. In column D put Ship when there is stock and the order is paid, otherwise Hold. In column E give the reason: Backorder when stock is zero, Awaiting payment when it is unpaid, and Ready otherwise.
Learning Objectives:
- Combine AND inside IF
- Nest IF for three outcomes
- Order tests from most specific
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Order | Stock | Paid | Decision | Reason |
| 2 | A-101 | 5 | Yes | ||
| 3 | A-102 | 0 | Yes | ||
| 4 | A-103 | 12 | No | ||
| 5 | A-104 | 3 | Yes |
What this exercise teaches (contains the answer)
The order of the nested tests is the whole exercise. Checking payment before stock would label A-102 as awaiting payment when it is paid for and simply not in the warehouse — a nested IF returns the first branch that matches, so the most specific case goes first.