Logical
Modern
OR
Returns TRUE if at least one condition is TRUE.
Available in All versions
Syntax
OR(logical1, [logical2])What it returns
TRUE if any argument is TRUE; FALSE only if all are FALSE.
Arguments
| Argument | Required | Description |
|---|---|---|
logical1 |
Yes | The first condition to test. |
logical2 |
No | Additional conditions to test (up to 255). |
Example
| A | B | |
|---|---|---|
| 1 | Tier | Spend |
| 2 | Standard | 1500 |
ResultTRUE
OR is TRUE if at least one condition holds. Tier is not VIP, but Spend 1500 > 1000, so the result is TRUE.
=OR(A2="VIP", B2>1000)Important to know
Returns FALSE only when every condition is FALSE.
Commonly used inside IF as the logical_test.