OpenOffice3.org Calc 3. Logical Functions
NOT(Logical value) Function
The function returns a logical value.
Reverses the value of the argument “logical value”. The argument contains an
expression that returns a logical value or a reference to a cell containing a
formula that returns a logical value. If the argument contains the logical value
FALSE, the function returns TRUE. On the other hand, if the argument contains a
logical value TRUE, the function returns FALSE. For example:
=NOT(A4<5) The argument is an expression, if the contents of cell A4 is less
than 5, the argument takes the logical value TRUE in this case, the function
returns FALSE because it reverses the logical value of the argument.
=NOT(TRUE()) Returns FALSE. The result is the logical value TRUE, the function
returns FALSE.
=NOT(FALSE()) Returns TRUE. The argument is FALSE. The function returns TRUE.