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)

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

×