The OR operator checks if at least one of the conditions is true: if one of them is true, it returns true. It is useful when you want a formula to validate as soon as a single criterion, among several, is met. It returns a boolean result (true/false).
Syntax
condition1 OR condition2
Examples
Check at least one condition
The condition is true if age is greater than 18, or if city is Paris.
age > 18 OR city == "Paris"
If age > 18 or if city == "Paris", the formula returns true. If neither condition is true (for example someone aged 17 living in Lyon), the formula returns false.
Go further
AND
The operator that requires all conditions to be true, unlike OR.
Or continue with
Formula glossary
All available operators and functions, sorted by category.