The NOT operator inverts the result of a condition: a true condition becomes false, a false condition becomes true. It returns a boolean (true/false).
Syntax
NOT condition
Examples
Invert a simple condition
Check whether the age is not greater than 18.
NOT age > 18
If the age is greater than 18, the condition age > 18 is true, but NOT turns it into false. If the age is 18 or less, the condition is false, but NOT turns it into true.
Combine NOT with several conditions
NOT can apply to the result of an OR.
NOT(age > 18 OR city == "Paris")
If age > 18 or city == "Paris", NOT returns false. If age <= 18 and the city is not "Paris", NOT returns true.
Go further
AND
The operator that checks whether all conditions are true.
Or continue with
Formula glossary
All available operators and functions, sorted by category.