How to use Excel ISLOGICAL Function

how to use excel islogical function

Quick Intro

Use Excel ISLOGICAL Function to check if a cell has a logical value or not. If there is a logical value in the cell it will return TRUE else FALSE.

In simple words, if a cell has a value TRUE or FALSE it will return TRUE else it will return FALSE.

Syntax

ISLOGICAL(value)

  • value  A value which you want to evaluate.

More Information on Excel ISLOGICAL Function

  • You also directly enter a value into the function.
  • It will return error is value is an error.

Examples

Here I have used different arguments for this function.

Example For Excel ISLOGICAL Function

  • In the first cell, I have entered a simple entered a TRUE value & in the second cell, I have used TRUE Function. It has returned TRUE for both of the values as both of the values are logical values.
  • In the third & fourth cell, I have used FALSE value & FALSE Function respectivley & it has returned the same result for both of the value.
  • As logical values, TRUE & FALSE has numeric values 1 & 0 as well but ISLOGICAL will not treat these number logical values.
  • If you use a text to evaluate, it will return FALSE.
  • For a blank a cell it will return FALSE.
  • If a value contains an error it will return a #N/A value.

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel ISLOGICAL Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have ISFORMULA function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.