ISLOGICAL Function - Excel

Overview

The ISLOGICAL function in Excel is a useful tool for checking if a given value is a logical (boolean) value. The function will return a TRUE value result if the specified value is equal to TRUE or FALSE and will return a FALSE value result when the specified value is not a logical (boolean) value.

An example of the ISLOGICAL function in Excel

Example:

=ISLOGICAL("TRUE")

Syntax:

=ISLOGICAL(value)

value: This is the value or reference to the cell you want to check for being a logical value.

TRUE Example

In this example, the ISLOGICAL function returns a TRUE value result because C2 equals "TRUE” which is a logical (boolean) value.

An example of the ISLOGICAL function in Excel with a TRUE value output

FALSE Example

In this example, the ISLOGICAL function returns a FALSE value result because C2 equals "Apple” and that is not a logical (boolean) value.

An example of the ISLOGICAL function in Excel with a FALSE value output

Interactive GSheet