Documentation/How Tos/Calc: NOT function

CALC FUNCTIONS

Logical Functions

< Previous Section

Next Section >

FUNCTIONS

• And
• False
• If
• Not
• Or
• True

< Previous Page

Next Page >

NOT

Reverses the logical value. Returns TRUE if the argument is FALSE, and FALSE if the argument is TRUE.

Syntax:

NOT(logical_value)

where logical_value is the logical value to be reversed.

Example:

NOT( TRUE() )

returns FALSE

Issues:

• Entering =NOT(TRUE) in a cell correctly returns FALSE, but the display in the formula bar is =NOT(1). See Issue 84266.

---

See Also

• AND
• OR
• TRUE
• FALSE

• Logical functions

• Functions listed alphabetically
• Functions listed by category