Home/Formulas/Logic/OR
Logiceasy

OR()

Returns TRUE if any of the provided arguments are logically true.

Syntax
fx
=OR(logical_expression1, [logical_expression2, ...])
Arguments
ArgumentDescription
logical_expression1An expression or reference that represents a logical value.
[logical_expression2, ...]Additional expressions or references. Any one true value makes OR return TRUE.
Try it
F2
→
TRUE
Sample data · sales.csv
ABCD
1CompanyRegionQuarterRevenue
2Acme CoWestQ118,400
3Acme CoWestQ222,100
4Acme CoWestQ331,700
5Acme CoWestQ448,200
6GlobexEastQ114,200
7GlobexEastQ219,800
8GlobexEastQ323,400

Common pitfalls

  • Like AND, OR returns a single boolean even when given ranges. For row-by-row OR inside array contexts use + instead.
  • Empty cells coerce to FALSE; numeric zero is FALSE; any other number is TRUE.
  • If you only need to test if ANY cell in a range matches a value, COUNTIF(range, value) > 0 is often clearer than OR.
Related formulas
AND()
Returns TRUE if all of the provided arguments are logically true.
NOT()
Returns the opposite of a logical value: NOT(TRUE) = FALSE.
IF()
Returns one value if a condition is TRUE, another if FALSE.
Used by
IF()
Returns one value if a condition is TRUE, another if FALSE.
AND()
Returns TRUE if all of the provided arguments are logically true.
NOT()
Returns the opposite of a logical value: NOT(TRUE) = FALSE.
More Logic formulas →Keyboard shortcuts for Sheets →