What is AND called in Spanish?

In Spanish Excel 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 in Mexico).

Why does AND use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel AND function

Returns TRUE only when every condition is true. It is almost always used inside IF. In Spanish Excel it is called Y.

Syntax

English Excel

=AND(logical1, [logical2], …)

Spanish Excel (Mexico)

=Y(valor_lógico1, [valor_lógico2], …)

Spanish Excel (Spain, Latin America)

=Y(valor_lógico1; [valor_lógico2]; …)

Argument	What it is
logical1	The first condition.
logical2optional	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

In Spanish Excel the function is simply Y. It does not work inside FILTER; multiply the conditions there instead.

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/94

My Excel is inExcel 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 Excel 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 in Mexico).
Why does AND use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common AND mistake?: In Spanish Excel the function is simply Y. It does not work inside FILTER; multiply the conditions there instead.