Module 3 · Lesson 10
AND and OR
Combine requirements and alternative decision routes.
Use AND for requirements that work together
AND is appropriate when every rule must be satisfied, such as reaching a sales target and maintaining an acceptable return rate.
=IF(AND(B2>=C2,D2<5%),"Bonus","Review")Use OR for alternative routes
OR is appropriate when any one condition is enough, such as escalating an order that is late or unusually expensive.
=IF(OR(E2="Late",B2>10000),"Check","OK")Key takeaway: AND requires every condition to be true; OR requires at least one condition to be true.