=NOT
The NOT function returns the opposite of the Boolean value provided. If the input is TRUE, it returns FALSE. If the input is FALSE, it returns TRUE.
For numeric values, zero is treated as FALSE and all non-zero numbers are treated as TRUE.
Syntax
Section titled “Syntax”=NOT(BooleanParameter)Parameters
Section titled “Parameters”BooleanParameter – The Boolean value, expression, or numeric value to evaluate and reverse.
How It Works
Section titled “How It Works”-
Evaluates the provided Boolean or numeric value.
-
Converts numeric values to Boolean logic if needed.
-
Returns the opposite Boolean result.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
Useful for reversing logical conditions in formulas.
-
Numeric value rules:
-
0 = FALSE
-
Any non-zero number = TRUE
-
-
Often combined with logical functions like IF, AND, and OR.
Examples
Section titled “Examples”=NOT(True)Returns
Section titled “Returns”False
=NOT(False)Returns
Section titled “Returns”True
=NOT(6252)Returns
Section titled “Returns”False
=NOT(0)Returns
Section titled “Returns”True
Keywords
Section titled “Keywords”NOT, Boolean logic, reverse condition, logical negation, true false formulas, workflow formulas, formula function