The ISLOGICAL function checks if the value is logical.
Returns TRUE if it is and FALSE if not.
This function is useful when creating complex formulas for processing various types of input data.
Syntax
ISLOGICAL(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Value that is checked for belonging to a logical value |
Any value (number, text, formula, cell reference, and so forth) |
Examples of use
Checking a cell for a logical value
=ISLOGICAL(A1)
This formula returns TRUE if cell A1 contains the value TRUE or FALSE, and FALSE otherwise.
Checking the result of a logical expression
=ISLOGICAL(B2>100)
The formula checks whether the result of the expression B2>100 is a logical value (always returns TRUE, since the comparison yields a logical result).
Use in combination with the IF function
=IF(ISLOGICAL(C3), "Logical value", "Non-logical")
If cell C3 contains the value TRUE or FALSE, “Logical value” is returned; otherwise, “Non-logical” is returned.
Notes
–The ISLOGICAL function returns TRUE only for the values TRUE and FALSE.
–For numbers, text, errors, and other data types, FALSE is returned.
–This function is often used in conjunction with other function for checking types: ISNUMBER, ISTEXT, ISERROR.