NOT
Syntax
NOT(logical_expression)
logical_expression- An expression or reference to a cell holding an expression that represents some logical value, i.e.TRUEorFALSE.
Notes
- Because
0has a logical value ofFALSEand any non-zero numeric value has a logical value ofTRUE,NOT(0)returnsTRUEandNOT(6)returnsFALSE. However, when non-numeric values are input intoNOT, the function returns the error#VALUE!.
See Also
FALSE: Returns the logical value `FALSE`.
TRUE: Returns the logical value `TRUE`.
Examples
Reverses the logical value.
