The ISERR function tests if a supplied value or expression returns an error, except the #N/A error. If the expression or value results in an error, the function returns the logical value TRUE. If the value is not an error or is the #N/A error, the function returns FALSE.

Syntax

=ISERR(value)

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!

Arguments

Argument Description
value Normally, value is supplied as a cell address.

Examples

  A B C D
1 Value Formula Result Notes
2 #DIV/0! =ISERR(A2) TRUE  
3 #NAME? =ISERR(A3) TRUE  
4 #N/A =ISERR(A4) FALSE Does not return TRUE for #N/A
5 #REF! =ISERR(A5) TRUE  
6 #NUM! =ISERR(A6) TRUE  
7 #VALUE! =ISERR(A7) TRUE