What is IFERROR called in Spanish?

In Spanish Google Sheets it is SI.ERROR. The formula =IFERROR(B2/C2,"No units") is written =SI.ERROR(B2/C2;"Sin piezas") (or with commas under a Mexico locale).

Why does IFERROR use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets IFERROR function

Returns a formula’s result or, if it errors, the value you choose. In Spanish Sheets it is called SI.ERROR.

Syntax

English Sheets

=IFERROR(value, [value_if_error])

Spanish Sheets (Mexico locale)

=SI.ERROR(valor, [valor_si_error])

Spanish Sheets (Spain, Latin America)

=SI.ERROR(valor; [valor_si_error])

Argument	What it is
value	The formula that might error.
value_if_erroroptional	What to show instead; blank by default.

Example

If a formula errors, such as #DIV/0! when dividing by zero or by a blank cell, IFERROR(formula, value) shows the value you choose instead. Sheets writes errors the same way in every language.

=IFERROR(B2/C2,"No units")

Common mistake

It hides every error, including the ones that reveal a broken formula. Use it once you know which error to expect.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice IFERROR

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/59

My spreadsheet is inGoogle Sheets functions in English and Spanish

IFERROR

If a formula errors, such as #DIV/0! when dividing by zero or by a blank cell, IFERROR(formula, value) shows the value you choose instead. Sheets writes errors the same way in every language.

Example=IFERROR(B2/C2,0)SI.ERROR = IFERROR

In D2, divide the cost by the units; if that fails, show "No units".

	A	B	C	D
1	Product	Total cost	Units	Cost per unit
2	Screws	450	300
3	Nuts	380	0
4	Nails	225	150
5	Washers	190
6	Anchors	600	400
7

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is IFERROR called in Spanish?: In Spanish Google Sheets it is SI.ERROR. The formula =IFERROR(B2/C2,"No units") is written =SI.ERROR(B2/C2;"Sin piezas") (or with commas under a Mexico locale).
Why does IFERROR use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common IFERROR mistake?: It hides every error, including the ones that reveal a broken formula. Use it once you know which error to expect.