IFERROR Function in Excel
Intermediate
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
Syntax
=IFERROR(value, value_if_error)Example
Use Case
Display 'Not Found' instead of #N/A.
Common Errors to Avoid
- Catches ALL errors, including calculation errors you should fix
- Can hide legitimate errors in your formula logic
- Evaluates value argument twice (performance impact on complex formulas)
Pro Tips
Use specific error handling (IFNA for #N/A only) when possible. Don't use IFERROR to hide errors during development - fix them first. Good for user-facing sheets to show friendly messages.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →