Excel troubleshooting

Why Is IFERROR Not Working?

Fix IFERROR formulas that still show errors, hide the wrong value, or fail because of argument order and nested error chains.

Problem

  • IFERROR usually fails when the error happens outside the wrapped expression, when IFERROR itself is misspelled, or when a different error appears downstream.

Quick fix

  • Wrap the exact expression that produces the error, use IFNA for #N/A only, and fix the source formula before hiding the error message.

Common IFERROR mistakes

  • Only part of the formula is wrapped, so another argument still returns an error.
  • IFERROR hides a real data problem that should be fixed first.
  • The replacement value is text when the formula result must stay numeric.

Better alternatives

  • Use IFNA when you only want to catch #N/A from lookup functions.
  • Use IFERROR after confirming the lookup or reference logic is correct.
  • Combine IFERROR with data cleanup functions like TRIM and VALUE.

Frequently asked questions

  • IFERROR vs IFNA for lookups? IFNA only catches #N/A — better for VLOOKUP/XLOOKUP. IFERROR catches every error type.
  • Why do I still see #REF! with IFERROR? The error may be outside the wrapped expression. Wrap the full formula or fix the broken reference.
  • Does IFERROR hide data problems? Yes — fix lookup logic first, then add IFERROR for user-friendly display.