# 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) |
m |
||

Line 31: | Line 31: | ||

* [[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]]}} | ||

− | [[Category: Documentation/Reference/Calc]] | + | [[Category: Documentation/Reference/Calc/Information functions]] |

## Revision as of 07:25, 19 April 2010

## ISLOGICAL

Tests if a cell contains a logical value, ` TRUE` or

`.`

**FALSE**### Syntax:

**ISLOGICAL(value)**

- Returns
if**TRUE**is either**value**or**TRUE**, and**FALSE**otherwise.**FALSE**

### Example:

**ISLOGICAL(D5)**

- where D5 contains
, returns**FALSE**, because D5 contains a logical value.**TRUE**

**ISLOGICAL(123)**

- returns
, because**FALSE**is a number, not a logical value.**123**

### 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.