Difference between revisions of "Documentation/How Tos/Calc: ISLOGICAL function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 22: | Line 22: | ||
* [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]] | * [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]] | ||
* [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]] | * [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]] | ||
− | * [[Documentation/How_Tos/Calc: ISFORMULA function|ISFORMULA]] | + | * [[Documentation/How_Tos/Calc: ISFORMULA function|ISFORMULA]] |
− | * [[Documentation/How_Tos/Calc: Information functions|Information functions]] | + | * [[Documentation/How_Tos/Calc: Information functions|Information functions]] |
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
Revision as of 14:17, 26 February 2009
ISLOGICAL
Tests if a cell contains a logical value, TRUE or FALSE.
Syntax:
ISLOGICAL(value)
- Returns TRUE if value is either TRUE or FALSE, and FALSE otherwise.
Example:
ISLOGICAL(D5)
- where D5 contains FALSE, returns TRUE, because D5 contains a logical value.
ISLOGICAL(123)
- returns FALSE, because 123 is a number, not a logical value.
Template:Documentation/SeeAlso
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.