NOT

Name

Logical Not

Description

Reverses the logical value of its argument.

Syntax

NOT(value)

Remarks

If the specified value is zero, then the function returns 1 (True). If the specified value is a value other than zero, then the function returns zero (False). Provide a numeric or logical value for the value argument.

See also AND, FALSE, IF, OR, and TRUE.

Data Type

Accepts numeric (boolean) data. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

NOT(R1C2)
NOT(A3)
NOT(12) = 0 (False)