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

Syntax:

NOT(Value)

Description:

Performs a logical negation. TRUE becomes FALSE and FALSE becomes TRUE.

Value must be a logical value or a calculation returning a logical value.

Example:

NOT(TRUE) returns FALSE

NOT(FALSE) returns TRUE

NOT(A1=0) returns TRUE, if A1 contains a value different from zero.

See also:

OR, AND, XOR