Documentation/How Tos/Calc: ISLOGICAL function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 07:25, 19 April 2010 by Mwaller (Talk | contribs)

Jump to: navigation, search


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.

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