How To Use Excel ISERR Function

    how to use excel iserr function

    Quick Intro

    Excel ISERR Function will tell you that if there is any error in a cell. Just like ISERROR Function, It will check about the error in cell excluding #N/A. In simple words, it will return TRUE if there is any error in the cell other than #N/A.

    Definition For Excel ISERR Function

    Syntax

    ISERR(value)

    • value A cell reference or a value from which you want to check the error.

    More Information on Excel ISERR Function

    • ISERR will verify an error in both conditions, either that error is in an absolute value or is a result of another formula.
    • Evaluate all types of error from a cell #DIV/0! #NAME? #NULL! #NUM! #REF! & #VALUE! but not #N/A. To check #N/A, you can use ISNA Function or ISERROR Function.

    Examples

    In the below example, I have used ISERR With If Statement to get a specific text if there is any error in a cell.

    Use Excel ISERR Function With IF Function

    In the below example, I have used ISERR With An Array Range to check the error from a range of cells.

    Use Excel ISERR Function With Array

    You can also use this formula with other Excel Function to create some dynamic formulas.

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel ISERR 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 ISERROR function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.