IFERROR in Excel & Google Sheets
Returns a value you choose when a formula results in an error like #N/A or #DIV/0!, and the normal result otherwise.
Syntax
=IFERROR(value, value_if_error) Example: Avoid #DIV/0! in a ratio
=IFERROR(C2/B2, 0) =SI.ERROR(C2/B2; 0) Divides C2 by B2, and shows 0 when B2 is empty or zero.
IFERROR in Spanish
In Spanish Excel and Google Sheets, IFERROR is called SI.ERROR. 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 | IFERROR | SI.ERROR |
| Separator | , | ; |
| Example | =IFERROR(C2/B2, 0) | =SI.ERROR(C2/B2; 0) |
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
IFERROR FAQ
What is IFERROR in Spanish?
In Spanish, IFERROR is SI.ERROR. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =SI.ERROR(C2/B2; 0)
Does IFERROR work in Google Sheets?
Yes. IFERROR works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called SI.ERROR. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.
How do I use IFERROR with VLOOKUP?
Put the VLOOKUP inside: =IFERROR(VLOOKUP(E2, A2:C6, 3, FALSE), "Not found"). When the value doesn't exist you see the text instead of #N/A.