How to Check Whether a Value is Logical Value

The ISLOGICAL Function checks whether a value is logical value. When it is a logical value, the result returns to "TRUE", and returns "FALSE" when it is not.

Formula:

=ISLOGICAL(value)

Explanations:

Value is required, the result returns TRUE when the value is a logical value and returns False when it is not.

Example:

=ISLOGICAL(A2)

Cell A2 is True which is a logical value, so ISLOGICAL(A2) returns to True.

=ISLOGICAL(A4)

Cell A4 is the text "6F" which is not a logical value, so ISLOGICAL(A4) returns to False.

Download ISLOGICAL Function

Leave a Reply