Home › IFNA
IFNA in every language
| Language | Name | Syntax | LibreOffice | Sheets |
|---|---|---|---|---|
| English | IFNA | IFNA(value, value_if_na) | — | — |
| German | WENNNV | WENNNV(Wert; Wert_bei_NV) | WENNNV | WENNNV |
| French | SI.NON.DISP | SI.NON.DISP(valeur; valeur_si_na) | SINA | SI.NON.DISP |
| Spanish | SI.ND | SI.ND(value; valor_si_nd) | SI.ND | SI.ND |
| Portuguese (Brazil) | SENÃODISP | SENÃODISP(valor; valor_se_não.disp) | SE.É.NÃO.DISP | SENÃODISP |
| Dutch | ALS.NB | ALS.NB(waarde; waarde_indien_niet_bekend) | ALS.NB | ALS.NB |
| Italian | SE.NON.DISP. | SE.NON.DISP.(valore; valore_se_nd) | SE.NON.DISP | SE.NON.DISP. |
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.