OR
Returns TRUE if any argument is TRUE.
LogicalBeginner EssentialsLogic & ConditionsMost Used
What it does
Returns TRUE if any condition is TRUE.
Syntax
OR(logical1, [logical2], ...)
Arguments
logical1(logical) — First condition to test.
Examples
Any condition can pass
Check if Region is "EU" OR "UK".
FORMULA
=OR(A2="EU",A2="UK")
RESULT
true
SAMPLE DATA
| A | |
|---|---|
| 1 | Region |
| 2 | EU |
| 3 | US |
| 4 | UK |