Documentation/How Tos/Calc: NOT function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 20:09, 5 December 2007 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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


See also:

AND function, OR function, TRUE function, FALSE function

Logical functions


Issues:

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