Conditional Logic

Excel formula for Hide errors with IFERROR

Return a clean fallback instead of #DIV/0!, #N/A, or other errors.

Copy this formula

=IFERROR(A2/B2, 0)

How the formula works

IFERROR runs the formula and, if it errors, returns your fallback (a 0, a blank "", or a message). It's the standard way to keep reports tidy when divisions or lookups can fail.

Examples

=IFERROR(VLOOKUP(A2, T, 2, FALSE), "Not found")→Not found

Replaces #N/A with a message.

Other ways to do this

Only catch #N/A

=IFNA(VLOOKUP(A2, T, 2, FALSE), "")

IFNA leaves other errors visible.

FAQ

Is hiding all errors a good idea?

Be careful — IFERROR hides real mistakes too. Use IFNA when you only want to suppress not-found results.

Related formulas

VLOOKUP that returns blank, not #N/A Flag or handle blank cells

Functions used

IFERROR IFNA

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free