Formula Library

IFERROR

logical

Returns a custom value if a formula results in an error, otherwise returns the formula's result.

Syntax

=IFERROR(value, value_if_error)

Example

Excel
=IFERROR(VLOOKUP(A2,D:E,2,FALSE), "Not found")

Runs the VLOOKUP, but if it returns any error, shows "Not found" instead.

Tips & Notes

  • →Use "" (empty string) to show nothing on error
  • →Use 0 to return zero on error for math calculations
  • →IFNA only catches #N/A errors specifically

See Also

IFVLOOKUP

Need a custom IFERROR formula?

Describe exactly what you need and get the formula generated instantly.

Generate →

We use cookies and display ads via Google AdSense to keep ExcelBossPro free. Privacy Policy. By continuing, you accept our use of cookies.