BeginnerLogical Functions
Flag reps below target with IF
Use IF to label each rep as meeting or missing their target.
IF
5 min15 points
IF
Returns one value when a test is true and another when it is false.
Syntax
IF(logical_test, value_if_true, value_if_false)
Logical Functions.
Practise IF13 interactive exercises, free, no account needed
Need the formula for your own sheet? Use the IF Formula Generator
A worked example
=IF(D2>=1,"Met","Below")
Returns Below
Returns Met when achievement is 100% or more, otherwise Below.
Where it goes wrong
Comparing a percentage-formatted cell against 100 rather than 1. The cell displays 95% but holds 0.95, so >=100 is never true.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- Correct for this row, but typing the answer means every row says Met when you fill it down — and Alan is well under target.Flag reps below target with IF
- AND demands both conditions at once, so only the order that is rush *and* fragile gets flagged. The warehouse wants either one to be enough.Flag orders needing special handling with OR
- The policy says MORE than 30 days, so this invoice — sitting at exactly 30 — is still current. Using >= flags it a day early. Use > instead.Flag overdue invoices with IF and TODAY
- This handles the balance-and-overdue rule but drops the disputed accounts, so Riverbend never gets called. The dispute check needs to sit alongside it.Flag accounts for review with AND and OR
Practise IF
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
- 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 - IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points - IntermediateLogical Functions
Approve orders with AND
Require two conditions to be true at once.
IF · AND
8 min25 points