Home › Functions › Logical › IFERROR
fx
IFERROR
Logical  ·  Since: Excel 2007  ·  9 languages

You can use the IFERROR function to handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

🌐 Translations

English IFERROR
Deutsch WENNFEHLER
Français SIERREUR
Español SI.ERROR
Italiano SE.ERRORE
Português SEERRO
Nederlands ALS.FOUT
Polski JEŻELI.BŁĄD
Русский ЕСЛИОШИБКА

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

IFERROR(value,value_if_error)

Arguments

value (required) — The argument that is checked for an error.
value_if_error (required) — The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

▶ Examples

=IFERROR(A2/B2,"Error in calculation")
=IFERROR(A3/B3,"Error in calculation")
=IFERROR(A4/B4,"Error in calculation")

Related functions

Copied to clipboard