Skip to content

Iferror Excel guide: Everything you need to know

  • by
  • 2 min read

Excel is one of the tools in Microsoft 365. It is one of the most widely used spreadsheet software and is compatible with most available platforms.

With the IFERROR function, you can trap and handle errors in a formula. If there is an error in the formula, then this function returns the value you specify; otherwise, it returns the result of the formula.

IFERROR Syntax

Here is the syntax of the IFERROR function:

IFERROR (value, value_if_error), where:

  • value is the argument that you need to check for an error. You can enter a formula, expression, value, or cell reference here.
  • value_if_error is the value you want to see if the formula evaluates an error. It can be a blank cell, text message, number, or another formula.

Here is an example of how to use the IFERROR function:

As you can see from the screenshot I have divided the value in C4 to D4. The answer is 5 as shown in cell C8. Notice the IFERROR formula that I have used. Now, on to the next screenshot.

Next, I tried to divide 35 by 0. This time we see an Invalid error in the cell. Because our value_if_error was an Invalid error.

You can enter a blank space, number, or empty string using the same method. Just change the value_if_error to your desired variable.

The IFERROR function evaluates the following types of errors:

  • #N/A – This error code occurs when there is no value in the cell.
  • #VALUE! – The formula or cell referencing is wrong.
  • #REF! – Invalid cell reference.
  • #DIV/0! – When you divide a number by zero.
  • #NUM! – Invalid numerical values.
  • #NAME? – You have included text in the formula without using the double quotes.
  • #NULL! – Use of incorrect range operator in the formula.

Also read: Excel not responding: 7 Fixes

Kumar Hemant

Deputy Editor at Candid.Technology. Hemant writes at the intersection of tech and culture and has a keen interest in science, social issues and international relations. You can contact him here: kumarhemant@pm.me

>
Exit mobile version