IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points
Flag campaigns over budget by a margin
The situation
Every Harbor Supply campaign lands a little either side of its budget, and flagging every dollar of overspend produced a report nobody read. Finance only wants to see campaigns that went more than ten percent over.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Campaign | Budget | Actual | Status | |
| 2 | Trade Show Q3 | $12,000 | $12,400 | ||
| 3 | Spring Catalog | $5,000 | $5,840 | ||
| 4 | Reorder Reminder | $2,000 | $1,850 | ||
| 5 | Search Brand | $6,000 | $7,100 | ||
| 6 | Winter Preview | $3,000 | $3,200 | ||
| 7 |
Functions in this exercise
- IF — Returns one value when a test is true and another when it is false. Syntax and example
Who this is for
Recommended next
Related exercises
- BeginnerLogical Functions
Flag reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 points - IntermediateLogical Functions
Work out fill rate without a divide error
Guard a division so cancelled lines do not fill the report with errors.
IF
8 min25 points - BeginnerLogical Functions
Flag orders needing special handling with OR
Mark an order when either of two independent conditions is true.
OR · IF
5 min15 points