Home › IF

IF in every language

LogicalLegacyLast verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishIFIF(logical_test, value_if_true, [value_if_false])——
GermanWENNWENN(Prüfung; Dann_Wert; [Sonst_Wert])WENNWENN
FrenchSISI(test_logique; valeur_si_vrai; [valeur_si_faux])SISI
SpanishSISI(prueba_lógica; valor_si_verdadero; [valor_si_falso])SISI
Portuguese (Brazil)SESE(teste_lógico; valor_se_verdadeiro; [valor_se_falso])SESE
DutchALSALS(logische_test; waarde_als_waar; [waarde_als_onwaar])ALSALS
ItalianSESE(test; se_vero; [se_falso])SESE

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 IF