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)
Result:
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
Note:
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.
