IFERROR Generator - Hide Errors, Show Fallback | Excel & Sheets
Returns a value you specify if a formula evaluates to an error; otherwise returns the result of the formula.
IFERROR: The Essential Error Handler
IFERROR is one of the most important functions for creating robust spreadsheets. It catches errors like #DIV/0!, #N/A, #VALUE!, and #REF! and replaces them with a clean value.
Common Use Cases
- VLOOKUP with IFERROR:
=IFERROR(VLOOKUP(A1, B:C, 2, FALSE), "Not Found") - Division protection:
=IFERROR(A1/B1, 0) - Clean reports: Replace ugly error messages with blank cells or custom text
Pro Tip: Wrap any lookup or division formula in IFERROR to create professional, error-free reports.
Common Errors & Fixes
IFERROR hides errors I want to see
Causes:- Using IFERROR around a formula that can return #VALUE! or #REF! you need to fix.
- Nested formulas: inner error is caught so outer logic never runs.
Fixes:- Use IFNA instead to catch only #N/A, or fix the inner formula first.
- Test the inner formula without IFERROR to debug, then wrap once correct.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More