IFERROR in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | IFERROR | SI.ERROR |
| Syntax | =IFERROR(value, value_if_error) | =SI.ERROR(value; value_if_error) |
| Example | =IFERROR(A1/B1,0) | =SI.ERROR(A1/B1;0) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What IFERROR does
Replaces an error result with a value you choose. Example: Divides A1 by B1 and shows 0 if that causes an error.
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
It hides every kind of error, including ones that point to real mistakes.
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 IFERROR?
It hides every kind of error, including ones that point to real mistakes.