Excel IFERROR Function

HomeTop 100 Excel Functions with Examples – A Complete List Including Samples FilesHow to use IFERROR Function in Excel (Example + Sample File)

What is EXCEL IFERROR FUNCTION

The Excel IFERROR Function is listed under Microsoft Excel's Logical Functions category. It returns a specific value if an error occurs. In simple words, it can test value and if that value is an error it returns the value you have specified.

How to use it

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

Syntax

IFERROR(value, value_if_error)

Arguments

  • value: The value you want to test for the error.
  • value_if_error: The value which you want to get in return when an error occurs.

Notes

  • IFERROR function is concerned with the occurrence of an error, not with the type of the error.
  • If you skip specifying value or value_if_error, it will return 0 in the result.
  • It can test #N/A, #REF!, #DIV/0!, #VALUE!, #NUM!, #NAME?, and #NULL!.
  • If you are evaluating an array it will return an array of results for each item specified.

Example

To master the IFERROR 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 the IFERROR function to replace the #DIV/0! with some meaningful text.

IFERROR is only compatible with 2007 and earlier versions. To deal with this problem, you can use ISERROR.

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.