IFERROR()
Returns a fallback value if a formula evaluates to an error, otherwise returns the formula's normal result.
IFERROR(value, value_if_error)IFERROR catches any error a formula could produce — #N/A, #REF!, #DIV/0!, #VALUE!, and the rest — and substitutes a fallback instead of showing the error on the sheet.
It's most commonly wrapped around a lookup: IFERROR(VLOOKUP(...), "Not found") so a missing value shows a clean message instead of #N/A.
Use it carefully — swallowing every error type can also hide genuine mistakes in the formula itself, not just expected "not found" cases.
Arguments
- value
- The formula or value to evaluate.
- value_if_error
- What to return if value evaluates to an error.
Examples
=IFERROR(VLOOKUP(D2,A:B,2,FALSE), "Not found")→Not found
Replaces #N/A with a readable message.
=IFERROR(A2/B2, 0)→0
Avoids #DIV/0! when B2 is zero or blank.