ISLOGICAL

Check if cell returns a logical value in Excel
Returns TRUE if the value is a logical value

Rational

Check if cell returns a logical value (i.e., TRUE or FALSE).

Description

The Excel ISLOGICAL function check if a specified cell has boolean value and returns “TRUE” when a cell has a boolean data type, and “FALSE” when a cell does not have a boolean data type.

Syntax

=ISLOGICAL(value)

Parameters

value – Refer cell to check a boolean data type

Return Value

Boolean value (TRUE or FALSE)

Key Notes

The ISLOGICAL formula returns TRUE for only those queries which return its value as ‘TRUE’.For example: “=ISLOGICAL(5=5)” return TRUE and “=ISLOGICAL(5=6)” return FALSE.

The ISLOGICAL formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.

Keep Reading Similar Functions:

Check a cell for valid reference in Excel

ISREF

The ISREF function checks if a cell has a correct reference, returns “TRUE” when a cell has a valid reference, and “FALSE” for reference error or not linked.

Read More »

ISFORMULA

The ISFORMULA function check if a specified cell is containing a formula and returns “TRUE” if it contains, I.e., cell C6 =2+2, “=ISFORMULA(C6)” returns TRUE.

Read More »
Check if a cell is blank in Excel

ISBLANK

The ISBLANK function checks if a cell is blank and returns “TRUE” when it is, I.e., “=ISBLANK(“Text”)” return FALSE as the cell contains some value “Text”.

Read More »