Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 »
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 »

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 »