Introduction
IFERROR helps you catch mistakes in formulas and show a friendly message or value instead of an error. It makes your spreadsheet look clean and easier to understand when something goes wrong.
When dividing numbers and you want to avoid showing a division by zero error.
When looking up data that might not exist and you want to show a message like 'Not found'.
When calculating with data that might be missing or incomplete and you want to show zero or blank instead of an error.
When you want to keep your report tidy by replacing errors with a simple text or number.
When you want to avoid breaking other formulas that depend on your calculation.