ReferenceFunctionsLogical Functions
OR
OR: Returns TRUE when any supplied value evaluates to TRUE.
Summary
OR evaluates arguments left to right and short-circuits on a decisive TRUE.
Remarks
- Booleans and numbers are accepted (
0is FALSE, non-zero is TRUE). - Blank values are ignored.
- Text and other non-coercible values yield
#VALUE!if no prior TRUE short-circuits. - If no TRUE is found, the first encountered error is returned.
Examples
One truthy value makes OR true
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
true
No true values and text input
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
#VALUE!
Related functions
FAQ
How does OR treat blanks and text?
Blanks are ignored; non-coercible text returns #VALUE! unless a prior TRUE already short-circuits.
Runtime metadata
Category
Logical
Signature
OR(arg1…: Any)This function accepts a repeating argument pattern (min args: 1).
Arity
min 1, max variadic
Arguments
arg1Any · Scalar
Caps
PUREREDUCTIONBOOL_ONLYSHORT_CIRCUIT
Source