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