The NOT operator is used to invert the result of a condition or a logical expression. It transforms a true value into false, and a false value into true.
➡️ Display Name:
NOT()
➡️ Syntax:
NOT
condition
➡️ Example:
NOT
age
>
18
OR
city
==
"Paris"
In this example, NOT OR will return false if the age is greater than 18 or if the city is Paris. If neither condition is met, the result will be true.
- 1st condition 🟡: age > 18
- 1 operator 🟣: OR
- 2nd condition 🟡: city == "Paris"
- NOT 🟣: Inverts the result of the OR.
🟰 Expected Result:
- If age > 18 or if city == "Paris", NOT OR will return false.
- If age <= 18 and the city is not Paris, NOT OR will return true.
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...