What is AND called in Spanish?

In Spanish Google Sheets it is Y. The formula =IF(AND(B2>=95,C2>=8),"Yes","No") is written =SI(Y(B2>=95;C2>=8);"Sí";"No") (or with commas under a Mexico locale).

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

Returns TRUE only when every condition holds. In Spanish Sheets it is called Y.

Syntax

English Sheets

=AND(logical_expression1, [logical_expression2], …)

Spanish Sheets (Mexico locale)

=Y(expresión_lógica1, [expresión_lógica2], …)

Spanish Sheets (Spain, Latin America)

=Y(expresión_lógica1; [expresión_lógica2]; …)

Argument	What it is
logical_expression1	The first condition.
logical_expression2optional	More conditions.

Example

AND returns TRUE only when all its conditions are met. Inside IF, it requires several things at once.

=IF(AND(B2>=95,C2>=8),"Yes","No")

Common mistake

Inside ARRAYFORMULA it does not work row by row: AND collapses the whole range into one result. Multiply conditions there instead: (A2:A10>5)*(B2:B10="Yes").

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 AND

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

IF with AND

AND returns TRUE only when all its conditions are met. Inside IF, it requires several things at once.

Example=IF(AND(B2>=95,C2>=8),"Sí","No")SI = IF Y = AND

The bonus ("Yes") requires attendance of 95 or more and a review of 8 or more. Otherwise, "No".

	A	B	C	D
1	Employee	Attendance %	Review	Bonus
2	Marisol	98	9
3	Fernando	92	9.5
4	Gabriela	95	8
5	Hugo	100	7.5
6	Daniela	97	8.5
7

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

Frequently asked questions

What is AND called in Spanish?: In Spanish Google Sheets it is Y. The formula =IF(AND(B2>=95,C2>=8),"Yes","No") is written =SI(Y(B2>=95;C2>=8);"Sí";"No") (or with commas under a Mexico locale).
Why does AND 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 AND mistake?: Inside ARRAYFORMULA it does not work row by row: AND collapses the whole range into one result. Multiply conditions there instead: (A2:A10>5)*(B2:B10="Yes").