IntermediateLogical Functions
Approve orders with AND
Require two conditions to be true at once.
IF · AND
8 min25 points
AND
Returns TRUE only when every condition is true.
Syntax
AND(logical1, [logical2], ...)
Logical Functions.
Practise AND2 interactive exercises, free, no account needed
Need the formula for your own sheet? Use the IF Formula Generator
A worked example
=IF(AND(C2="OK",B2<5000),"Auto","Review")
Returns Auto
Auto-approves only when credit is clear AND the value is under $5,000.
Where it goes wrong
Swapping AND for OR inverts the rule while still producing plausible-looking output, which makes it easy to miss.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- OR passes when either condition holds, so a $6,200 order from a good customer would auto-approve. Both conditions must be true here, which means AND.Approve orders with AND
- 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 AND
Knowing what a function does and being able to write it from memory are different skills. These close the gap.