ISLOGICAL function

ISLOGICAL returns TRUE if the cell contains a logical number format. The function is used to check for both TRUE and FALSE values in cells. If an error occurs, the function returns a logical or numeric value.

Syntax

ISLOGICAL(value)

value is the value to be tested for logical number format.

Example

=ISLOGICAL(D5) returns FALSE.