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 58572;84266 .

---

See Also

• AND
• OR
• TRUE
• FALSE

• Logical functions

• Functions listed alphabetically
• Functions listed by category