Documentation/Calc Functions/ISLOGICAL
Appearance
	
	
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/0and 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