# Documentation/Calc Functions/ISLOGICAL

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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
`=1/0`

and thus displays the #DIV/0! error, then`=ISLOGICAL(F1)`

returns FALSE rather than the error. Similarly`=ISLOGICAL(SQRT(-2))`

returns FALSE rather than an error.

## Examples:

Formula | Description | Returns |
---|---|---|

=ISLOGICAL(99) | Here the function returns FALSE because 99 is a number, not a logical value. The value of the number is not significant - for example the formulas `=ISLOGICAL(0)` and `=ISLOGICAL(1)` both return FALSE. |
FALSE |

=ISLOGICAL(D1) where cell D1 contains the value FALSE. | Here the function returns the logical value TRUE because cell D1 contains a logical value – which logical value is not important. | TRUE |

=ISLOGICAL(ISNA(D4)) | Here the function returns the logical value TRUE whatever the contents of cell D4, because the ISNA function returns a logical value. | TRUE |

## Related LibreOffice functions:

## ODF standard:

## Related (or similar) Excel functions:

ISLOGICAL