Exercises / Logic and decisions · 9 of 9
Pending until shipped
A cell is empty when it equals "" (two quotes, nothing between). ISBLANK(C2) asks the same question. Use either as an IF test.
Your taskIn D2, use IF to return "Pending" when the shipped date in C2 is empty, and "Shipped" otherwise. It will be copied down to D8.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Order | Ordered | Shipped | Status |
| 2 | #5001 | 25 Sep 2026 | 27 Sep 2026 | |
| 3 | #5002 | 26 Sep 2026 | ||
| 4 | #5003 | 26 Sep 2026 | 29 Sep 2026 | |
| 5 | #5004 | 28 Sep 2026 | 30 Sep 2026 | |
| 6 | #5005 | 29 Sep 2026 | ||
| 7 | #5006 | 30 Sep 2026 | 1 Oct 2026 | |
| 8 | #5007 | 1 Oct 2026 |