The OR operator is used to check if at least one of the conditions is true. If one of the conditions is true, the OR operator will return true.
➡️ Display Name:
➡️ Syntax:
➡️ Example:
In this example, the condition will be true if the age is greater than 18, or if the city is Paris. If one of these two conditions is true, the result will be true.
- 1 condition 🟡: age > 18 is the first condition to check.
- 1 operator 🟣: OR checks if at least one condition is true.
- 1 condition 🟡: city == "Paris" is the second condition to check.
Expected Result:
- If age > 18 or if city == "Paris", the formula will return true.
- If neither condition is true, the formula will return false.
💡 Practical Use:
The OR operator is very useful when you have multiple criteria and want to validate if at least one of those criteria is true.
🆎 Comparison with AND:
Unlike the AND operator, which requires all conditions to be true to return true, the OR operator only needs one condition to be true to return a true result.
In this example, both conditions must be true for the formula to return "Valid".
Before You Start
Getting Started with Formulas
The new formulas in Timetonic allow you to transform, calculate, and manipulate the information stored in your columns by combining multiple functions...
Or Continue With
Glossary View of Formulas
Quickly find the function or operator you're looking for or simply explore and learn how to use them...