Resources > Formula Help
How Do I Use IFERROR in Excel?
Last Updated: June 2026
Quick Answer
IFERROR returns a custom result when a formula produces an error.
=IFERROR(A2/B2,0)
IFERROR Syntax
=IFERROR(value, value_if_error)
Example with XLOOKUP
=IFERROR(XLOOKUP(E2,A:A,B:B),"Not found")
When to Use IFERROR
- Cleaning up reports
- Replacing ugly error messages
- Handling missing lookup results
- Preventing dashboard visuals from breaking
Warning
Do not use IFERROR to hide problems you should actually fix. It can make broken formulas look clean while the underlying issue remains.
