Catching Errors With IFERROR

The IFERROR function is your all-purpose safety net. It checks whether a formula produces any error, and if it does, it shows a friendly value you choose instead.

This keeps your spreadsheet looking clean and professional. Instead of scary codes like #DIV/0! scattered across a report, you see helpful text such as a blank or a dash.

In this lesson you will learn the IFERROR syntax and how to apply it to real formulas.

IFERROR takes exactly two arguments:

• value the formula or calculation to try
• value_if_error what to show if that formula errors

The pattern is =IFERROR(your_formula, fallback). The spreadsheet runs your formula first. If it works, you see the real answer. If it errors, you see the fallback instead.

Recall that dividing by an empty cell gives #DIV/0!. Wrapping the division in IFERROR fixes the display.

Here, if B2 is zero or blank, the formula returns 0 instead of the error. If B2 has a real number, the normal division runs.

You could also return a blank by using two quotation marks, "", as the fallback.

IFERROR shines with lookups. A VLOOKUP that finds no match returns #N/A, which can confuse readers.

By wrapping the lookup, you can replace that with a clear message like "Not found". Now anyone reading the sheet understands the result instantly.

This single technique makes lookup-heavy reports far easier to trust and share.

The fallback does not have to be plain text. It can be another formula to run when the first one fails.

For example, if a primary lookup misses, you can fall back to a secondary lookup in a different table. The spreadsheet tries the first, and only on error does it try the second.

This lets you chain attempts gracefully without ugly errors in between.

An important feature: IFERROR catches every error type. It does not matter whether the formula throws #DIV/0!, #N/A, #VALUE!, or #REF! the fallback is shown for all of them.

This is powerful but also a warning. Because it hides every error, IFERROR can mask real problems you would rather know about.

If you only want to hide missing lookups, IFNA is a safer choice, which you will learn next lesson.

Suppose you calculate growth percentage as this period minus last period, divided by last period. If last period is zero, you get #DIV/0! for new products.

Wrapping it in IFERROR with the text "New" turns those errors into a meaningful label. Established products show a real percentage; brand new ones show New.

The report now reads cleanly from top to bottom.

Because IFERROR is so broad, be careful where you place it. If you wrap an entire complicated formula, a #VALUE! error caused by bad data could be silently replaced.

You might then trust a number that is actually wrong. The best practice is to wrap the specific part most likely to error, not the whole calculation.

Use IFERROR deliberately, and during testing remove it temporarily to confirm your formula really works.

A common style choice is to return an empty string for missing data so the cell simply looks blank.

Using "" as the fallback keeps charts and totals tidy, since most functions treat blank-looking text as nothing visible.

Be aware though: a cell holding "" is technically text, not truly empty, which can affect some COUNT or chart behaviors. For totals it is usually safer to return 0.

Use IFERROR when you want a single, simple safety net over a formula and you are confident any error is expected and harmless.

Great cases include division ratios, optional lookups, and growth calculations on new items.

Avoid it when you need to know about unexpected errors, or when only one specific error type should be handled. For lookups specifically, IFNA gives finer control, coming up next.

You can place one IFERROR inside another to try several fallbacks in order. The spreadsheet tries the first formula, then the second, then a final default.

Here it looks in the main table, then a backup table, and if both miss it returns "Not found". Each layer only runs when the previous one errors.

Keep nesting shallow, two or three levels at most, or the formula becomes hard to read and maintain.

Test your understanding of IFERROR.

You learned the all-purpose error handler:

• =IFERROR(value, value_if_error) tries a formula and shows a fallback if it errors.
• It catches every error type, so use it deliberately.
• The fallback can be text, a number, a blank "", or even another formula.
• Wrap the risky part, not the whole calculation, so real problems stay visible.

Next you will meet IFNA, which targets only the #N/A lookup error.