Return TRUE when at least one condition is true.
Syntax
OR(logical1, [logical2], …)Arguments
logical1required
The first condition to test.
logical2…optional
Additional conditions.
OR returns TRUE if any of its conditions hold, and FALSE only when all fail. Combine it with IF to act when any one of several situations applies — for example, flagging a row if it's overdue OR over budget.
=OR(B2="VIP", C2>1000)→TRUETRUE if the customer is VIP or spent over 1000.
List the conditions
Separate each test with a comma.
Wrap in IF to act
Use OR in IF's logical test to trigger on any match.
Yes — nest them, e.g. IF(AND(A2>0, OR(B2="X", B2="Y")), ...), to express complex rules.