Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.
5 exercises — Logical Functions · for Operations
Mark an order when either of two independent conditions is true.
OR · IF
Require two conditions to be true at once.
IF · AND
Guard a division so cancelled lines do not fill the report with errors.
IF
Combine two logical tests so one condition can override the other.
AND · OR · IF
Read a code's prefix and translate it into a readable category name.
IFS · LEFT
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 32 | Flag orders needing special handling with ORHarbor Supply — warehouse pick list | OR · IF | Beginner | 5 min | 15 pts |
| 43 | Approve orders with ANDHarbor Supply — order approval queue | IF · AND | Intermediate | 8 min | 25 pts |
| 49 | Work out fill rate without a divide errorHarbor Supply — fill rate by line, some cancelled | IF | Intermediate | 8 min | 25 pts |
| 55 | Flag accounts for review with AND and ORHarbor Supply — accounts receivable review | AND · OR · IF | Intermediate | 9 min | 30 pts |
| 64 | Turn a product code into a categoryHarbor Supply — SKU category decode | IFS · LEFT | Intermediate | 9 min | 30 pts |