Documentation/Calc Functions/ISLOGICAL

Function name:
ISLOGICAL

Category:
Information

Summary:
Determines whether the supplied argument results in a logical value (TRUE or FALSE).

Syntax:
ISLOGICAL(Value)

Returns:
Returns TRUE if the argument evaluates to a logical value and FALSE otherwise.

Arguments:
Value is an expression, or a reference to a cell containing an expression, that is to be tested to determine if it evaluates to a logical value.

Additional details:

 * Although a logical value in Calc is simply a number with a Boolean format, ISLOGICAL returns FALSE if the supplied argument evaluates to any number.


 * ISLOGICAL does not propagate errors. For example, if cell F1 contains the formula  and thus displays the #DIV/0! error, then   returns FALSE rather than the error. Similarly   returns FALSE rather than an error.

Related LibreOffice functions:
ISTEXT

ISNUMBER

ODF standard:
Section 6.13.19, part 2

Equivalent Excel functions:
ISLOGICAL