IFS in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | IFS | SI.CONJUNTO |
| Syntax | =IFS(logical_test1, value_if_true1, ...) | =SI.CONJUNTO(logical_test1; value_if_true1; ...) |
| Example | =IFS(A1>90,"A",A1>80,"B",TRUE,"C") | =SI.CONJUNTO(A1>90;"A";A1>80;"B";VERDADERO;"C") |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What IFS does
Checks several conditions in order and returns the first match. Example: Returns A above 90, B above 80, otherwise C.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
If no condition is true you get #N/A, so end with TRUE as a catch-all.
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with IFS?
If no condition is true you get #N/A, so end with TRUE as a catch-all.