NOT

Microsoft Datasheet View

NOT

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 TRUE; if logical is TRUE, NOT returns FALSE.

Example

Formula Description (Result)
=NOT(FALSE) Reverses FALSE (TRUE)
=NOT(1+1=2) Reverses an equation that evaluates to TRUE (FALSE)