OR()
Returns TRUE if any argument is true.
OR(logical1, [logical2], ...)OR evaluates a list of conditions and returns TRUE if at least one holds, FALSE only when every condition fails.
Like AND, it's most useful nested inside IF rather than used on its own — for example, flagging a row as urgent if either its priority is High or its due date has passed.
OR has the same single-value limitation as AND, with the same workaround: addition rather than multiplication, since any non-zero total means at least one condition held. Where OR is genuinely useful is as a compact membership test over an array — =OR(A2=$F$2:$F$20) asks whether a value appears anywhere in a list without a COUNTIF. For a handful of alternatives on one field, though, a criteria array inside SUMPRODUCT or the IN-style pattern of COUNTIF against a range is usually easier for the next reader to follow.
Arguments
- logical1
- The first condition to test.
- logical2, ...optional
- Additional conditions to test — any may be TRUE.
Examples
=OR(B2="High", C2<TODAY())TRUE if priority is High or the due date is already past.
=IF(OR(B2="High", C2<TODAY()), "Urgent", "Normal")OR nested inside IF.
=OR(EXACT(A2, $F$2:$F$20))OR over an array returns TRUE if any element matches — a case-sensitive is-this-value-in-my-list test.
Notes and gotchas
- Like AND, OR returns a single value. For per-row OR inside
FILTERorSUMPRODUCT, add the conditions instead:(A2:A99="North")+(A2:A99="South")and test>0. - OR is true if any argument is true, so it short-circuits conceptually but still evaluates all arguments.
- For "exactly one of these", use
XORrather than OR. - Checking whether a value is one of a list is usually better done with
COUNTIF(list, value)>0than with a long OR chain — the list is then data you can edit rather than formula text.
Common errors
| You see | Because | Fix |
|---|---|---|
| #VALUE! | No argument resolved to a logical value or number. | Check that the arguments are comparisons, not text strings describing comparisons. |
OR tricks, tips, and workbook hacks
OR returns TRUE as soon as at least one of its arguments is TRUE, and returns FALSE only when every single argument fails. It is the natural way to group exception flags—such as flagging an order if Payment is Overdue OR Credit Limit is Exceeded OR Account is On Hold.
Just like AND, OR collapses arrays to a single scalar result, so inside FILTER() or SUMPRODUCT() you should add boolean arrays with + rather than wrapping them in OR().
Quick OR checks before trusting the result
- For checking one cell against 4+ allowed text values, =OR(A2={"North","South","East","West"}) or =ISNUMBER(MATCH(A2, AllowedRange, 0)) is much cleaner than repeating A2= four times.
- When combining AND and OR in the same rule, nest carefully so your parentheses reflect the exact business rule.
- Inside FILTER(), replace OR(cond1, cond2) with (cond1)+(cond2)>0.
| OR pattern | OR formula | Best use | Watch out |
|---|---|---|---|
| Match one cell against an array constant of values | =IF(OR(B2={"Sat","Sun"}),"Weekend","Weekday") | Testing whether a cell equals any one of several strings without writing B2="Sat", B2="Sun" repeatedly. | OR automatically evaluates the array equality and returns TRUE if any element matches. |
| Nested AND + OR approval rule | =IF(AND(C2="Active",OR(D2>10000,E2="VIP")),"Priority","Standard") | Routing accounts that must be Active AND either high-spend OR marked VIP. | Check closing parentheses around OR() before closing AND(). |
| Flag rows with missing data in any critical column | =IF(OR(A2="",B2="",C2=""),"Missing Field","OK") | Pre-upload validation checklists before importing spreadsheets into an ERP. | Catches both truly empty cells and formula empty strings (""). |
| OR mistake | What happens in OR | Fix |
|---|---|---|
| Using OR for negative exclusions ('not X or not Y') | =OR(A2<>"Cancelled", A2<>"Refunded") is ALWAYS TRUE because no cell can be both Cancelled and Refunded at the same time! | When excluding multiple values, you want AND: =AND(A2<>"Cancelled", A2<>"Refunded") (De Morgan's law). |
| Using OR() inside FILTER() | =FILTER(A2:C100, OR(B2:B100="East", B2:B100="West")) fails with #VALUE!. | Add the boolean arrays instead: =FILTER(A2:C100, (B2:B100="East")+(B2:B100="West")). |
OR practice drills
- Test De Morgan's trap on a status column: compare =OR(B2<>"Closed", B2<>"Void") against =AND(B2<>"Closed", B2<>"Void").



