For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
=FUNCTIONS

OR()

Logical

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

TRUE if priority is High or the due date is already past.

=IF(OR(B2="High", C2<TODAY()), "Urgent", "Normal")
→Urgent

OR nested inside IF.

=OR(EXACT(A2, $F$2:$F$20))
→TRUE

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 FILTER or SUMPRODUCT, 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 XOR rather than OR.
  • Checking whether a value is one of a list is usually better done with COUNTIF(list, value)>0 than with a long OR chain — the list is then data you can edit rather than formula text.

Common errors

What goes wrong with OR, and why
You seeBecauseFix
#VALUE!No argument resolved to a logical value or number.Check that the arguments are comparisons, not text strings describing comparisons.
Tips / Tricks / Hacks

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 tricks and formula patterns
OR patternOR formulaBest useWatch 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 ("").
Common OR mistakes and how to fix them
OR mistakeWhat happens in ORFix
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

  1. Test De Morgan's trap on a status column: compare =OR(B2<>"Closed", B2<>"Void") against =AND(B2<>"Closed", B2<>"Void").

Related functions