< Go Back

Excel ISERROR Function

Want to learn more about how to test any error type excel generates by using excel spreadsheet? This post will give you an overview of how to use Excel ISERROR function and how to test error types in excel.

Formula

The generic syntax for Excel ISERROR function is:

=ISERROR(value)

Where,

Value is the error value generated by excel formulas that you want to test like, #N/A, #NAME?, #VALUE!,  #DIV/0!, #REF!, #NUM!, or #NULL

Explanation

The Excel ISERROR function in excel returns TRUE if the value is an error value. This includes error like #NULL, #VALUE!,  #DIV/0!, #REF!, #NUM!, #N/A and#NAME? error values. Otherwise, in excel the ISERROR function will return FALSE.

The ISERROR function is an already built-in function in Excel that is categorized as an informative Function. ISERROR function can be used as a VBA function and a worksheet function (WS) in Excel.

Excel ISERROR function combined with IF function can be used to default a cell value when the error is encountered. This Function allows our formulas to work with evaluating data completely without requiring the user’s intervention.

Example

To find the result of the test for any error, Excel ISERROR function can be used. In the example selected cell shown, the formula in C5 is:

=ISERROR(B5)

It returns TRUE if the supplied value is an error value or a formula returns an error. It returns FALSE if a value is other than error value.

Figure 1: Example of Test for any error

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar