Documentation/Calc Functions/NOT

Function name:
NOT

Category:
Logical

Summary:
Determines the logical complement or negation of a Boolean value, reversing true values to false and false values to true.

Syntax:
NOT(Logical Value)

Returns:
Returns either TRUE (1) or FALSE (0), giving the logical complement of the supplied logical value.

Arguments:
Logical Value is an expression, or a reference to a cell containing an expression, that can be evaluated to a logical value TRUE or FALSE. If Logical Value is evaluated to a number instead of a logical value, then the value 0 (zero) is treated as FALSE, while any non-zero value is treated as TRUE.


 * If Logical Value cannot be evaluated as a logical value, then IF reports a #VALUE! error.

Related LibreOffice functions:
AND

Special:MyLanguage/Documentation/Calc_Functions/FALSE

IF

IFERROR

IFNA

IFS

OR

SWITCH

Special:MyLanguage/Documentation/Calc_Functions/TRUE

XOR

ODF standard:
Section 6.15.7, part 2

Equivalent Excel functions:
NOT