The ISERR Excel function is an Information formula that returns TRUE, if the reference value is an error code (except for #N/A), and FALSE otherwise. As the name suggests, the formula asks the "Is error?" question, and can be especially useful for troubleshooting and error handling. In this guide, we’re going to show you how to use the ISERR Excel function and also go over some tips and error handling methods.
Supported versions
- All Excel versions
ISERR Excel Function Syntax
Arguments
value | The value you want to test. |
Example
The ISERR function, like the other IS… functions, requires a single argument as an input. The argument can be a blank (empty) cell, a cell containing errors, logical values, strings, numbers, reference values, or a named range referring to any of these. The formula is most commonly used in testing the outcome of a cell or value that contains formulas. This way, you can quickly check cells containing errors. The function returns a TRUE logical value for errors like #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! (the function doesn't work with the #N/A error).
=ISERR(#N/A) returns FALSE
Tips
- The ISERR Excel function ignores #N/A errors.
- You can use the ISERR function in combination with an IF statement for a different outcome value than TRUE or FALSE. =IF(ISERR(A1),"Error","No error")
- IFERROR function can return a specific value if the target contains an error. Please note that the IFERROR function too doesn't work with the #N/A error.
- Below is a list of other IS… functions.