Logical

OR Function in Excel

Returns TRUE if any argument is TRUE; returns FALSE only if all arguments are FALSE.

Syntax

  • =OR(logical1, [logical2], ...)

Arguments

  • logical1 (required): First condition to evaluate
  • logical2 (optional): Additional conditions (up to 255)

Examples

  • =OR(A1="Red", A1="Blue") - Check if value is Red or Blue - Result: TRUE or FALSE
  • =IF(OR(B1>100, C1="Priority"), "Expedite", "Standard") - Check multiple criteria - Result: Expedite or Standard

Excel OR function documentation

  • OR returns TRUE if any argument is TRUE — FALSE only when all arguments are FALSE.
  • Syntax: =OR(logical1, [logical2], …). Pairs with [IF](/functions/if/) for multi-trigger rules.
  • Example: =IF(OR(A2="Urgent", B2>30), "Escalate", "Normal").
  • Related: [AND](/functions/and/), [NOT](/functions/not/), [IFS](/functions/ifs/).

OR syntax and patterns

  • Use OR when different conditions should produce the same outcome.
  • Combine with AND: =AND(A2>0, OR(B2="X", B2="Y")).
  • OR(ISBLANK(A2), A2=0) — treat blank and zero similarly.
  • Do not confuse with bitwise OR — Excel OR is logical only.

Step-by-step: flag exceptions for review

  • Step 1 — Review if Status is "Error" OR Amount > 10000 OR DaysLate > 7.
  • Step 2 — =OR(D2="Error", C2>10000, E2>7).
  • Step 3 — Display: =IF(OR(...), "Review", "OK").
  • Step 4 — Conditional format rows where OR formula TRUE.
  • Step 5 — Replace long OR with lookup table + MATCH when status list grows.

OR vs nested IF vs SWITCH

  • OR — multiple triggers → one TRUE result.
  • Nested IF — each branch different output text.
  • SWITCH — match one expression to many exact values — not range tests.
  • IFS — ordered thresholds when outcomes differ per band.

Worked examples to copy

  • Weekend check: =OR(WEEKDAY(A2)=1, WEEKDAY(A2)=7).
  • Status bucket: =OR(B2="Open", B2="Pending").
  • IF wrapper: =IF(OR(A2="", B2=""), "Incomplete", "Complete").
  • With NOT: =IF(OR(NOT(ISBLANK(A2)), B2>0), "Proceed", "Stop").

People also ask

  • OR vs AND difference? — OR any true; AND all must be true.
  • OR with numbers? — Use comparisons OR(A2>0, B2>0) not OR(A2, B2).
  • OR in SUMPRODUCT? — Use (condition1)+(condition2) or logical arrays carefully.
  • OR empty arguments? — Avoid; can return errors or unexpected results.

Common errors

  • Returns TRUE if ANY condition is TRUE
  • Empty cells are ignored

Use cases

  • Alternative conditions
  • Flexible filtering
  • Exception handling

Frequently asked questions

  • How does OR function work in Excel? OR returns TRUE if ANY condition is TRUE. It only returns FALSE when ALL conditions are FALSE. Example: =OR(A1="Yes", B1="Yes", C1="Yes") is TRUE if any cell contains "Yes". Use OR when you need to check for alternatives.
  • How do I use OR with IF? Nest OR inside IF: =IF(OR(condition1, condition2), "Match", "No Match"). Example: =IF(OR(Status="Urgent", Days>30), "Follow Up", "OK") triggers follow-up if either condition is met.
  • Can I combine AND and OR in one formula? Yes: =IF(AND(A1>0, OR(B1="Yes", C1="Yes")), "Valid", "Invalid"). This requires A1>0 AND at least one of B1 or C1 to be "Yes". Use parentheses to control logic grouping.
  • How do I check if a cell contains any of multiple values? Use OR with multiple conditions: =OR(A1="Apple", A1="Orange", A1="Banana"). For longer lists, consider COUNTIF: =COUNTIF(FruitList, A1)>0 or SUMPRODUCT with wildcards.
  • What is the difference between OR and XOR? OR returns TRUE if one or more conditions are TRUE. XOR (exclusive or) returns TRUE only if an ODD number of conditions are TRUE. =OR(TRUE, TRUE) is TRUE. =XOR(TRUE, TRUE) is FALSE.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use OR

  • Alternative conditions — common Logical scenario for OR.
  • Flexible filtering — common Logical scenario for OR.
  • Exception handling — common Logical scenario for OR.

OR in the Logical category

  • Browse all Logical functions at /categories/logical/ for related formulas.
  • OR syntax: =OR(logical1, [logical2], ...)
  • logical1 (required): First condition to evaluate
  • logical2 (optional): Additional conditions (up to 255)
  • Confirm OR arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm OR arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • AND (/functions/and/): Returns TRUE if all arguments are TRUE; returns FALSE if any argument is FALSE.
  • NOT (/functions/not/): Reverses the logic of its argument. Returns FALSE if argument is TRUE, and TRUE if argument is FALSE.
  • IF (/functions/if/): Returns one value if a condition is TRUE and another value if it's FALSE.
  • XOR (/functions/xor/): Returns TRUE if an odd number of arguments are TRUE (exclusive OR).
  • IFS (/functions/ifs/): Checks multiple conditions and returns a value corresponding to the first TRUE condition.

Comparisons involving this function

  • IF vs IFS (/compare/if-vs-ifs/): Use IF for one condition with two outcomes. Use IFS when you need three or more ordered conditions without building a hard-to-read nested IF chain.

Errors to watch for

  • Returns TRUE if ANY condition is TRUE — review causes on linked error pages in the directory.
  • Empty cells are ignored — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter OR on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

OR worked examples to copy

  • =OR(A1="Red", A1="Blue") — Check if value is Red or Blue. Expected result: TRUE or FALSE.
  • =IF(OR(B1>100, C1="Priority"), "Expedite", "Standard") — Check multiple criteria. Expected result: Expedite or Standard.

OR reference summary for crawlers and offline review

  • OR belongs to the Logical category in Excel. Returns TRUE if any argument is TRUE; returns FALSE only if all arguments are FALSE.
  • Full syntax: =OR(logical1, [logical2], ...). Open /functions/or/ for parameters, FAQs, and related pages.
  • Common mistakes: Returns TRUE if ANY condition is TRUE; Empty cells are ignored
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.