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
OR
Returns TRUE when at least one condition is true.
Syntax
OR(logical1, [logical2], ...)
Logical Functions.
Practise OR3 interactive exercises, free, no account needed
Need the formula for your own sheet? Use the IF Formula Generator
A worked example
=IF(OR(C2="Hold",B2>10000),"Review","Auto")
Returns Auto
Flags for review when either condition is true.
Where it goes wrong
OR returns TRUE as soon as one condition matches, so a rule needing every condition met should use AND.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- 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
- 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 OR
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
- IntermediateLogical Functions
Flag accounts for review with AND and OR
Combine two logical tests so one condition can override the other.
AND · OR · IF
9 min30 points - IntermediateLogical Functions
Flag salaries outside their band
Check whether a salary falls below or above its grade band.
OR · IF
8 min25 points