# How to use Excel ISLOGICAL Function

How to use Excel ISLOGICAL Function2016-04-29T09:57:32+00:00

## 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.

• 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.

• 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.

## 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.