How to use ISERR Function in Excel

The Excel ISERR function returns TRUE for any error type except the #N/A error. You can use the ISERR function together with the IF function to test for an error and display a custom message, or perform a different calculation if found.

Syntax:= ISERR (value)

The ISERR function syntax has the following arguments:

  • Value (required argument) – This is the expression or value that needs to be tested. It is generally provided as a cell address.

Example: Let’s look at some Excel ISERR function examples and explore how to use the ISERR function as a worksheet function in Microsoft Excel:

ISERR Function - How to use ISERR Function in Excel

Syntax:  =ISERR(A2)

Result:

ISERR Function in Excel - How to use ISERR Function in Excel

Based on the Excel spreadsheet above, the following ISERR examples would return:

Syntax: =ISERR(A3)
Result: TRUE

Syntax: =ISERR(A4)
Result: FALSE

Syntax: =ISERR(A5)
Result:TRUE

Syntax: =ISERR(A6)
Result: FALSE

Syntax: =ISERR(A72)
Result: FALSE

Syntax: =ISERR(A8)
Result: FALSE

Syntax: =ISERR(A9)
Result:FALSE

Note:

Use the ISERR function to see if a cell has an error except for #N/A. This includes #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!

For example, =ISERR(A1) will return TRUE if A1 is is displaying the error message mentioned above.

Normally, value is supplied as a cell address.

ISERR is part of a group of functions called the “is” functions, which are often used to test the result of formulas for errors.

READ:  How to use YIELDMAT Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *