What is CHOOSE called in Spanish?

In Spanish Google Sheets it is ELEGIR. The formula =CHOOSE(B2,0.02,0.04,0.06) is written =ELEGIR(B2;0,02;0,04;0,06) (or with commas under a Mexico locale).

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

Returns the choice at the given position. In Spanish Sheets it is called ELEGIR.

Syntax

English Sheets

=CHOOSE(index, choice1, [choice2], …)

Spanish Sheets (Mexico locale)

=ELEGIR(índice, valor1, [valor2], …)

Spanish Sheets (Spain, Latin America)

=ELEGIR(índice; valor1; [valor2]; …)

Argument	What it is
index	The position: 1, 2, 3…
choice1	The first choice.
choice2optional	More choices.

Example

CHOOSE(index, choice1, choice2…) returns the choice at that position. Use it when a number (1, 2, 3) stands for a level or category.

=CHOOSE(B2,0.02,0.04,0.06)

Common mistake

An index below 1 or above the number of choices returns #VALUE!.

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 CHOOSE

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

CHOOSE

CHOOSE(index, choice1, choice2…) returns the choice at that position. Use it when a number (1, 2, 3) stands for a level or category.

Example=CHOOSE(B2,0.02,0.04,0.06)ELEGIR = CHOOSE

In C2, assign the commission by level: level 1 = 2%, level 2 = 4%, level 3 = 6%.

	A	B	C
1	Salesperson	Level	Commission
2	Carmen	3
3	Jorge	1
4	Lucía	2
5	Andrés	1
6	Paola	3
7

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

Frequently asked questions

What is CHOOSE called in Spanish?: In Spanish Google Sheets it is ELEGIR. The formula =CHOOSE(B2,0.02,0.04,0.06) is written =ELEGIR(B2;0,02;0,04;0,06) (or with commas under a Mexico locale).
Why does CHOOSE 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 CHOOSE mistake?: An index below 1 or above the number of choices returns #VALUE!.