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.
8 exercises — Intermediate · Logical Functions
Require two conditions to be true at once.
IF · AND
Return one of three labels depending on where a value falls.
IF
Mark a campaign only when it overspends by more than a tolerance.
IF
Guard a division so cancelled lines do not fill the report with errors.
IF
Return the right rate from several tiers without nesting.
IFS
Combine two logical tests so one condition can override the other.
AND · OR · IF
Check whether a salary falls below or above its grade band.
OR · IF
Read a code's prefix and translate it into a readable category name.
IFS · LEFT
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 43 | Approve orders with ANDHarbor Supply — order approval queue | IF · AND | Intermediate | 8 min | 25 pts |
| 45 | Band orders by size with nested IFHarbor Supply — October orders | IF | Intermediate | 9 min | 25 pts |
| 47 | Flag campaigns over budget by a marginHarbor Supply — campaign budget versus actual | IF | 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 |
| 50 | Apply commission tiers with IFSHarbor Supply — Q3 sales by rep | IFS | Intermediate | 10 min | 25 pts |
| 55 | Flag accounts for review with AND and ORHarbor Supply — accounts receivable review | AND · OR · IF | Intermediate | 9 min | 30 pts |
| 56 | Flag salaries outside their bandHarbor Supply — pay band audit | OR · IF | Intermediate | 8 min | 25 pts |
| 64 | Turn a product code into a categoryHarbor Supply — SKU category decode | IFS · LEFT | Intermediate | 9 min | 30 pts |