Documentation/How Tos/Calc: ISLOGICAL function

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.

See also:

ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISFORMULA

Information functions

Functions listed alphabetically, 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 Issue 84266.