NOT
Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value.
Syntax
NOT(logical)
Logical is a value or expression that can be evaluated to TRUE or FALSE.
Remark
If logical is FALSE, NOT returns TRUE; if logical is TRUE, NOT returns FALSE.
Example
| Formula | Description (Result) |
|---|---|
| =NOT(FALSE) | Reverses FALSE (TRUE) |
| =NOT(1+1=2) | Reverses an equation that evaluates to TRUE (FALSE) |