Sunday, February 19, 2017

NOT function

NOT function

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