IFS in Excel & Google Sheets
Checks conditions in order and returns the result of the first one that is true. Replaces long chains of nested IFs.
Syntax
=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2…]) Example: Letter grade from a score
=IFS(B2>=90, "A", B2>=70, "B", TRUE, "C") =SI.CONJUNTO(B2>=90; "A"; B2>=70; "B"; VERDADERO; "C") Returns "A" from 90, "B" from 70, and "C" for everything else (the final TRUE acts as "otherwise").
IFS in Spanish
In Spanish Excel and Google Sheets, IFS is called SI.CONJUNTO. It's the same function: files translate automatically when opened in another language. When you type it by hand, the name and the argument separator change.
| English | Spanish | |
|---|---|---|
| Function | IFS | SI.CONJUNTO |
| Separator | , | ; |
| Example | =IFS(B2>=90, "A", B2>=70, "B", TRUE, "C") | =SI.CONJUNTO(B2>=90; "A"; B2>=70; "B"; VERDADERO; "C") |
The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.
Translate another formulaArguments
IFS FAQ
What is IFS in Spanish?
In Spanish, IFS is SI.CONJUNTO. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =SI.CONJUNTO(B2>=90; "A"; B2>=70; "B"; VERDADERO; "C")
Does IFS work in Google Sheets?
Yes. IFS works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called SI.CONJUNTO. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.
How do I add an "otherwise" value to IFS?
Make TRUE the last condition: =IFS(B2>=90, "A", B2>=70, "B", TRUE, "C"). Without it, IFS returns #N/A when nothing matches.