how to use excel iferror functionQuick Intro

Use Excel IFERROR Function to test an error from a cell and replace that error with as a meaningful result. IFERROR can be your best friend if you are in fear of errors.

It was first introduced in the Excel 2007. Most of the times IFERROR is used with other formulas to test their errors and replace them.

Syntax

IFERROR(value, value_if_error)

  • value Refer to the value or cell from which you want to test the error.
  • value_if_error Value which you wants to get in return when an error occurs in value.

More Information On Excel IFERROR Function

  • 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, if 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.

Examples

In the below example, I have used the IFERROR Function to replace the #DIV/0! with some meaningful text as 10/0 has returned an error.

Examples For Excel IFERROR Function

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

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel IFERROR Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have ISERROR function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.