The ISERROR function tests if an initial supplied expression or value returns an error. If it does, the function returns the logical value TRUE; otherwise the function returns FALSE.

Syntax

=ISERROR(value)

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!

Arguments

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

Examples

  A B C D
1 Value Formula Result Notes
2   =ISERROR(SUM(3,6,5,8)/A2) TRUE The formula references an empty cell as the divisor resulting in a #DIV/0! error.
3 #NAME =ISERROR(A3) TRUE  
4 #N/A =ISERROR(A4) TRUE TRUE for #N/A, unlike ISERR
5 #REF! =ISERROR(A5) TRUE  
6 #NUM! =ISERROR(A6) TRUE  
7 #VALUE! =ISERROR(A7) TRUE