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) |
