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.