🔀 Logical Function · beginner
OR Function in Google Sheets
Returns TRUE if any argument is TRUE.
Syntax
OR(logical_expression1, [logical_expression2, ...])Returns: TRUE if any argument is TRUE.
Excel equivalent: OR (identical)
Parameters
| Name | Required | Description |
|---|---|---|
| logical_expression1, logical_expression2, ... | Required | Conditions. |
Examples
Either-or
=IF(OR(A2 = "VIP", A2 = "Premium"), "Discount", "Full")Discount for VIP or Premium.
Any blank
=OR(ISBLANK(A2), ISBLANK(B2), ISBLANK(C2))TRUE if any cell empty.
OR in FILTER
=FILTER(A:C, (B:B="X") + (B:B="Y"))Use + for element-wise OR.
When to use an alternative
- AND — All-of-many.
- + operator — Array formulas.
Common errors and how to fix them
Always TRUE
Cause: Wrong comparison.
Fix: Make each arg boolean.
Related functions
AND
Returns TRUE if ALL arguments are TRUE....
IF
Returns one value when a condition is true and a different value when false. The foundation of condi...
IFERROR
Returns a fallback value when a formula returns an error, otherwise returns the formula's result. Th...
IFS
Evaluates multiple conditions in order and returns the value associated with the first TRUE conditio...
SWITCH
Returns the value matching the first matching case. Lookup-style branching for equality matches....
Frequently Asked Questions
OR in FILTER?
Use + instead — OR collapses arrays.
XOR?
TRUE if ODD number of args are TRUE. Parity checks.