Difference between revisions of "Documentation/How Tos/Calc: NOT function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
m (Issues:)
 
Line 19: Line 19:
  
 
=== Issues: ===
 
=== Issues: ===
* Entering <tt>'''=NOT(TRUE)'''</tt> in a cell correctly returns <tt>'''FALSE'''</tt>, but the display in the formula bar is <tt>'''=NOT(1)'''</tt>. See {{bug|58572;84266}}.
+
* Entering <tt>'''=NOT(TRUE)'''</tt> in a cell correctly returns <tt>'''FALSE'''</tt>, but the display in the formula bar is <tt>'''=NOT(1)'''</tt>.  
 +
:: See {{bug|58572;84266}}.
  
 
{{SeeAlso|EN|
 
{{SeeAlso|EN|

Latest revision as of 13:44, 31 January 2024

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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_NOT_function&oldid=259829"
Views
Personal tools
Navigation
Tools
In other languages