Returns the logical opposite of the expression. TRUE values are returned as FALSE and vice-versa. For numeric values, zero is treated as FALSE, all other values are treated as TRUE.
Syntax
NOT(expression)
Arguments
expression Values or cell references to examine. Example
NOT(TRUE) returns FALSE
NOT(A2) returns TRUE if the value of cell A2 is zero.