How to use ISERROR Function in Excel

ISERROR is a logical function which is used to identify whether the cells being referred to has an error or not, this function identifies all the errors and if any type of error is found out in the cell it returns TRUE as result and if the cell has no errors it returns FALSE as the result, this function takes a cell reference as an argument.

Syntax:= ISERROR (value)

The ISERROR 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 ISERROR function examples and explore how to use the ISERROR function as a worksheet function in Microsoft Excel:

Syntax:  =ISERROR(A2)


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

Syntax: =ISERROR(A3)
Result: TRUE

Syntax: =ISERROR(A4)
Result: TRUE

Syntax: =ISERROR(A5)
Result: TRUE

Syntax: =ISERROR(A6)
Result: TRUE

Syntax: =ISERROR(A7)
Result: TRUE

Syntax: =ISERROR(A8)
Result: FALSE

Syntax: =ISERROR(A9)
Result: FALSE


Use the ISERROR function to see if a cell contains any error message, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!

For example, =ISERROR(A1) will return TRUE if A1 is is displaying an one of the errors mentioned above , and FALSE if not.

Frequently, value is supplied as a cell address, but you can use it to trap errors inside more complex formulas as well.

Add a Comment

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