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

FormulaDescriptionResult
=NOT(false)Reverses falsetrue
=NOT(1+1=2)Reverses an equation that evaluates to truefalse