Home › IFERROR

IFERROR in every language

LogicalLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishIFERRORIFERROR(value, value_if_error)——
GermanWENNFEHLERWENNFEHLER(Wert; Wert_falls_Fehler)WENNFEHLERWENNFEHLER
FrenchSIERREURSIERREUR(valeur; valeur_si_erreur)SIERREURSIERREUR
SpanishSI.ERRORSI.ERROR(valor; valor_si_error)SI.ERRORSI.ERROR
Portuguese (Brazil)SEERROSEERRO(valor; valor_se_erro)SEERROSEERRO
DutchALS.FOUTALS.FOUT(waarde; waarde_indien_fout)ALS.FOUTALS.FOUT
ItalianSE.ERRORESE.ERRORE(valore; valore_se_errore)SE.ERRORESE.ERRORE

Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.

Translate a formula with IFERROR