The following examples show how to use IFERROR in Excel in combination with other functions to accomplish more complex tasks.

To trap errors in Excel 2003 and earlier versions, use the ISERROR function in combination with IF, as shown in this example.

IFERROR was introduced in Excel 2007 and is available in all subsequent versions of Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, and Excel 365.If the value argument is a blank cell, it is treated as an empty string (''') but not an error.Depending on the contents of the value_if_error argument, IFERROR can replace errors with your custom text message, number, date or logical value, the result of another formula, or an empty string (blank cell).

The IFERROR function in Excel handles all error types including #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

You can also display your own message instead of Excel's standard error notation:ĥ things you should know about Excel IFERROR function Supply an empty string (') to the value_if_error argument to return a blank cell if an error is found: To prevent that from happening, use the IFERROR function to catch and handle errors the way you want. It can be an empty string (blank cell), text message, numeric value, another formula or calculation.įor example, when dividing two columns of numbers, you may get a bunch of different errors if one of the columns contains empty cells, zeros or text.

Value_if_error (required) - what to return if an error is found.

It can be a formula, expression, value, or cell reference.

Value (required) - what to check for errors.

Formula for subtraction in excel