Home › IFS

IFS in every language

LogicalExcel 2019+Last verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishIFSIFS(logical_test1, value_if_true1, [logical_test2], value_if_true2, [logical_test3], value_if_true3)——
GermanWENNSWENNS(Logiktest1; Wert_wenn_wahr1; [Logiktest2]; Wert_wenn_wahr2; [Logiktest3]; Wert_wenn_wahr3)WENNSIFS
FrenchSI.CONDITIONSSI.CONDITIONS(test_logique1; valeur_si_vrai1; [test_logique2]; valeur_si_vrai2; [test_logique3]; valeur_si_vrai3)SI.CONDITIONSIFS
SpanishSI.CONJUNTOSI.CONJUNTO(prueba_lógica1; valor_si_verdadero1; [prueba_lógica2]; valor_si_verdadero2; [prueba_lógica3]; valor_si_verdadero3)SI.CONJUNTOSI.CONJUNTO
Portuguese (Brazil)SESSES(teste_lógico1; valor_se_verdadeiro1; [teste_lógico2]; valor_se_verdadeiro2; [teste_lógico3]; valor_se_verdadeiro3)SESIFS
DutchALS.VOORWAARDENALS.VOORWAARDEN(logische_test1; waarde_als_waar1; [logische_test2]; waarde_als_waar2; [logische_test3]; waarde_als_waar3)ALS.VOORWAARDENIFS
ItalianPIÙ.SEPIÙ.SE(test_logico1; valore_se_vero1; [test_logico2]; valore_se_vero2; [test_logico3]; valore_se_vero3)PIÙ.SEIFS

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 IFS