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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
Line 17: Line 17:
 
: returns  <tt>'''FALSE'''</tt>
 
: returns  <tt>'''FALSE'''</tt>
  
 +
=== Issues: ===
 +
* A logical value in Calc is simply a number with a boolean format, not a separate type as in Excel. Some resulting incompatibilities are discussed in  [http://qa.openoffice.org/issues/show_bug.cgi?id=84266 Issue 84266].
  
 
{{Documentation/SeeAlso|
 
{{Documentation/SeeAlso|
Line 26: Line 28:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
=== Issues: ===
 
* A logical value in Calc is simply a number with a boolean format, not a separate type as in Excel. Some resulting incompatibilities are discussed in  [http://qa.openoffice.org/issues/show_bug.cgi?id=84266 Issue 84266].
 

Revision as of 08:39, 3 March 2009


TRUE

Returns the logical value TRUE.


Syntax:

TRUE()

The TRUE() function has no arguments, and always returns the logical value TRUE.


Example:

TRUE()

returns TRUE

NOT(TRUE())

returns FALSE

Issues:

  • A logical value in Calc is simply a number with a boolean format, not a separate type as in Excel. Some resulting incompatibilities are discussed in Issue 84266.

Template:Documentation/SeeAlso

Personal tools