Accepting Any Match With OR
Return TRUE when at least one condition passes using OR.
When Any Reason Will Do
Not every decision needs every box ticked. Sometimes a single reason is enough. A customer might earn free shipping if they spend over 50 dollars or hold a membership card. Either one alone qualifies.
The OR function handles this kind of logic. It returns TRUE when at least one of your conditions is true, and only returns FALSE when every condition fails.
Where AND is strict, OR is generous. This lesson shows you how to accept any match.
The Shape of OR
The OR function looks just like AND. You list logical tests separated by commas, and it checks each one:
- logical1 the first condition
- logical2 the next condition, and so on
You can supply up to 255 conditions. The result is a single TRUE or FALSE.
The difference from AND is the rule: OR needs only one true condition to give back TRUE.
=OR(logical1, logical2, ...)All lessons in this course
- Requiring Everything With AND
- Accepting Any Match With OR
- Flipping Logic With NOT
- Cleaner Branching With IFS