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.
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.
Practise AND
Knowing what a function does and being able to write it from memory are different skills. These close the gap.