Return TRUE when at least one condition is true.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
OR(logical1, [logical2], …)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)Result: TRUE
TRUE if the customer is VIP or spent over 1000.
Yes — nest them, e.g. IF(AND(A2>0, OR(B2="X", B2="Y")), ...), to express complex rules.