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.