IFERROR Function: syntax, examples, mistakes and translation notes
Returns a fallback value when a formula errors.
Syntax
=IFERROR(value, value_if_error)
Arguments
value
Expression to evaluate.
value_if_error
Fallback returned for any supported error type.
Worked examples
=IFERROR(10/0,"Check")
Returns “Check” instead of #DIV/0!.
=IFERROR(XLOOKUP(A2,IDs,Prices),"Not found")
Shows a friendly fallback when the lookup errors.
Practical tips
- Debug the inner formula before hiding its error.
- Use IFNA when only a missing-match #N/A condition is expected.
- Choose a fallback that makes missing data visible rather than silently converting every error to zero.
Common mistakes
- Wrapping an untested formula in IFERROR and hiding a broken reference.
- Using a blank fallback when downstream users need to know that data is missing.
Related functions
Frequently asked questions
What does IFERROR do?
Returns a fallback value when a formula errors.
Why might a IFERROR formula return an unexpected result?
Wrapping an untested formula in IFERROR and hiding a broken reference. Start by testing the smallest referenced range or condition independently before adding wrappers or fallbacks.
Check the complete formula
Function syntax is only one part of a working workbook. Paste the finished expression into the Formula Checker for structural warnings, the Formatter for readability or the Translator when a supported locale mapping is involved.
Testing note: examples are educational. Spreadsheet versions, locale settings, tables, named ranges and workbook data can change behavior, so validate important formulas with representative data.