What does the ISLOGICAL function do in Excel?

ISLOGICAL Function

 

ISLOGICAL function check for a logical (TRUE/FALSE) value in a cell. If the cell contains a logical (TRUE/FALSE) value, it will return TRUE otherwise it will return FALSE.

ISLOGICAL function in Excel

The ISLOGICAL function in a built-in function of “IS-family” in Excel and gives a Boolean (TRUE/FALSE) result. If the cell value is logical (TRUE/FALSE), it will return TRUE otherwise return FALSE.

Syntax of the function

=ISLOGICAL (value)

Arguments of the function

Value where the value of a cell is logical (TRUE/FALSE)

Return

If a cell value is logical (TRUE/FALSE), it will return as TRUE

If a cell value is not logical (TRUE/FALSE), it will return FALSE

Applicable

Excel 2000, Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example:-

In below-given table, we have data in “Cell Value” and “Function” columns. Apply the formula, like ISERROR, ISTEXT or so on. If any function gives the result as TRUE/FALSE and applies the ISLOGICAL function in that cell. If this gives a cell value as TRUE, this is a logical value otherwise it is not logical value.

ISLOGICAL Function

 

  • A cell contains #DIV/0! Error Value and we have applied ISERROR function in it. It gives us the result as TRUE. By applying ISLOGICAL function in this cell, we can get the result as TRUE. If the cell value contains a result as TRUE then it is a logical value. And if it provides the result is FALSE, we cannot consider it a logical value. 

 

  • This cell has a numeric value, so we applied ISNUMBER function. It will give us a TRUE/FALSE result. Applying ISLOGICAL function referring to this cell. If this gives the result as TRUE, is a logical value otherwise (FALSE) not a logical value.

 

  • In this, there are two numeric values “5” and “7”. We apply “EXACT” function here to get a result as TRUE/FALSE. But this gave us the result as FALSE. Referring to this cell will apply ISLOGICAL function. If a result is TRUE then it is a logical value otherwise (FALSE) not a logical value. 

 

  • Simple text values can never be a logical value. When we apply ISLOGICAL function it provides the result is FALSE, this is not a logical value. 

 

  • Same as simple numeric value can never become a logical value. When we apply ISLOGICAL function referring to this cell. It provides the result as FALSE so that this is not a logical value.

 

  • Now here is the twist if a cell contains a text value. Of course, it is not a logical value as we have discussed earlier. But now we will apply “ISTEXT” function here and this gives us the result as TRUE. Now we will apply ISLOGICAL function referring to this cell. If this gives the result as TRUE, is a logical value otherwise (FALSE) not a logical value.

 

Read the related post also:-

 

ISTEXT function in Excel

ISNUMBER function in Excel

ISERROR function in Excel

ISBLANK function in Excel

 

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.