Logical FunctionsAdvanced
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.
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 teachesMay contain 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.