Excel ISERROR Function

HomeExcel FunctionsExcel ISERROR Function (Example + Sample File)


The Excel ISERROR Function is listed under Microsoft Excel's Information Functions category.

How to use it

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




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


  • ISERROR will verify an error in both conditions, either that error is in absolute value or as a result of another formula.
  • It will evaluate all types of errors from a cell. #N/A, #DIV/0!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!.


To master the ISERROR function we need to try it out in an example and below is one which you can try out:

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

In the below example, we have used ISERROR with an array range to check the error 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.