IF in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | IF | SI |
| Syntax | =IF(logical_test, [value_if_true], [value_if_false]) | =SI(logical_test; [value_if_true]; [value_if_false]) |
| Example | =IF(A1>10,"High","Low") | =SI(A1>10;"High";"Low") |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What IF does
Returns one value when a test is true and another when it is false. Example: Shows High when A1 is above 10, otherwise Low.
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
Text results must be inside quotes, and every opening parenthesis needs a closing one.
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 IF?
Text results must be inside quotes, and every opening parenthesis needs a closing one.