Excel ISERR Function

HomeExcel FunctionsExcel ISERR Function (Example + Sample File)

What is EXCEL ISERR FUNCTION

The Excel ISERR Function is listed under Microsoft Excel's Information Functions category. It returns TRUE if a value is an error other than #N/A. Unlike ISERROR, you can check it considers all the errors except #N/A and if there's an error then it returns TRUE, else FALSE.

How to use it

To learn how to use the ISERR function in Excel, you need to understand its syntax and arguments:

Syntax

ISERR(value)

Arguments

  • value: A cell reference or a value from which you want to check the error.

Notes

  • ISERR will verify an error in both of the conditions, either that error is in absolute value or as a result of another formula.
  • It evaluates all types of error from a cell #DIV/0! #NAME? #NULL! #NUM! #REF!, and #VALUE! but not #N/A. To check #N/A, you can use ISNA and ISERROR.

Example

To master the ISERR function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used ISERR with IF to get a specific text if there is an error in the cell.

In the below example, we have used ISERR with an array range to check the errors from a range of cells.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.