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 function, ISNUMBER function, ISBLANK function, ISERROR function, ISFORMULA function

Information functions