Formula Functions > Functions M to Q > NOT |
This function reverses the logical value of its argument.
NOT(value)
Provide a numeric or logical value for the argument.
If the specified value is zero, then the function returns TRUE. If the specified value is a value other than zero, then the function returns FALSE.
Accepts boolean data (TRUE or FALSE). Returns boolean data (TRUE or FALSE).
NOT(A3)
NOT(R1C2)
NOT(D5>100)
NOT(0) gives the result TRUE
NOT(TRUE)gives the result FALSE
NOT(12) gives the result FALSE
This function is available in product version 1.0 or later.
AND | OR | Logical Functions