How To Use Excel ISERROR Function

    how to use excel iserror function

    Quick Intro

    Unlike, IFERROR Excel ISERROR Function will tell you that if there is any error in a cell. And, if there is any error in the cell value it will return TRUE else it will return FALSE.

    In simple words, it will verify the if there is any error in a cell. To use ISERROR just refer to the cell from where you want to verify the error.



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

    More Information on Excel ISERROR Function

    • ISERROR will verify an error in both conditions, either that error is in an absolute value or is a result of another formula.
    • It will evaluate all types of error from a cell. #N/A, #DIV/0!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!.


    In the below example, I have used ISERROR with IF to get a specific text if there is any error in a cell.

    Use Excel ISERROR Function With IF Function

    In the below example, I have used ISERROR with an array range to check the error from a range of cells.

    " Use Excel ISERROR Function In Arrays"

    Sample File

    download sample file to learn more about this tips

    What’s Next?

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