NOT

Microsoft Office Spreadsheet Functions

Show All

NOT

See Also

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

The example may be easier to understand if you copy it to a blank spreadsheet.

How?

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