Spread Formula Reference
NOT
Formula Functions > Functions M to Q > NOT

This function reverses the logical value of its argument.

Syntax

NOT(value)

Arguments

Provide a numeric or logical value for the argument.

Remarks

If the specified value is zero, then the function returns TRUE. If the specified value is a value other than zero, then the function returns FALSE.

Data Types

Accepts boolean data (TRUE or FALSE). Returns boolean data (TRUE or FALSE).

Examples

NOT(A3)

NOT(R1C2)

NOT(D5>100)

NOT(0) gives the result TRUE

NOT(TRUE)gives the result FALSE

NOT(12) gives the result FALSE

Version Available

This function is available in product version 1.0 or later.

See Also

AND | OR | Logical Functions