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 Yes; if logical is TRUE, NOT returns No.
Examples
| Formula | Description (Result) |
|---|---|
| =NOT(FALSE) | Reverses FALSE (Yes) |
| =NOT(1+1=2) | Reverses an equation that evaluates to TRUE (No) |