Skip to main content

ISLOGICAL

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)

ArgumentDescriptionPermitted values
valueValue that is checked for belonging to a logical valueAny 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.