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) |
No comments:
Post a Comment