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

The NOT function syntax has the following arguments:

  • value (Required) A value or expression that can be evaluated to TRUE or FALSE.

Remark

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