<< Click to Display Table of Contents >> NOT (logical NOT function)

Syntax:

NOT(Value)

Description:

This performs a logical negation. TRUE becomes FALSE and FALSE becomes TRUE.

Value must be a logical value or a calculation that returns a logical value.

Example:

NOT(TRUE) returns FALSE

NOT(FALSE) returns TRUE

NOT(A1=0) returns TRUE if A1 contains a value other than zero.

See also:

OR, AND, XOR