What is IFNA called in Spanish?

In Spanish Google Sheets it is SI.ND. The formula =IFNA(VLOOKUP(D2,$A$2:$B$6,2,FALSE),"No price") is written =SI.ND(BUSCARV(D2;$A$2:$B$6;2;FALSO);"Sin precio") (or with commas under a Mexico locale).

Why does IFNA 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 IFNA function

Like IFERROR, but only catches #N/A, the "not found" error. In Spanish Sheets it is called SI.ND.

Syntax

English Sheets

=IFNA(value, value_if_na)

Spanish Sheets (Mexico locale)

=SI.ND(valor, valor_si_nd)

Spanish Sheets (Spain, Latin America)

=SI.ND(valor; valor_si_nd)

Argument	What it is
value	The formula that might return #N/A.
value_if_na	What to show instead.

Example

IFNA is like IFERROR, but it only catches #N/A, the "not found" error. That way you do not hide other errors you do want to see.

=IFNA(VLOOKUP(D2,$A$2:$B$6,2,FALSE),"No price")

Common mistake

Use it around VLOOKUP or XLOOKUP so other errors, like a wrong column, still show.

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 IFNA

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

Your progress0/103

My spreadsheet is inGoogle Sheets functions in English and Spanish

IFNA

IFNA is like IFERROR, but it only catches #N/A, the "not found" error. That way you do not hide other errors you do want to see.

Example=IFNA(VLOOKUP(D2,$A$2:$B$6,2,FALSE),"Sin precio")SI.ND = IFNA BUSCARV = VLOOKUP XLOOKUP: same name in Spanish INDICE = INDEX

In E2, look up the price for the code in D2. If it does not exist, show "No price".

	A	B	D	E
1	Code	Price	Find	Price
2	P-101	1299	P-103
3	P-102	189	P-110
4	P-103	95	P-105
5	P-104	459	P-999
6	P-105	239
7

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

Frequently asked questions

What is IFNA called in Spanish?: In Spanish Google Sheets it is SI.ND. The formula =IFNA(VLOOKUP(D2,$A$2:$B$6,2,FALSE),"No price") is written =SI.ND(BUSCARV(D2;$A$2:$B$6;2;FALSO);"Sin precio") (or with commas under a Mexico locale).
Why does IFNA 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 IFNA mistake?: Use it around VLOOKUP or XLOOKUP so other errors, like a wrong column, still show.