What is MODE called in Spanish?

In Spanish Google Sheets it is MODA. The formula =MODE(B2:B8) is written =MODA(B2:B8) (or with commas under a Mexico locale).

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

Returns the most repeated number. In Spanish Sheets it is called MODA.

Syntax

English Sheets

=MODE(value1, [value2], …)

Spanish Sheets (Mexico locale)

=MODA(valor1, [valor2], …)

Spanish Sheets (Spain, Latin America)

=MODA(valor1; [valor2]; …)

Argument	What it is
value1	The first number or range.
value2optional	More numbers or ranges.

Example

The average gets pulled by extreme values. MEDIAN is the middle value of the sorted list and MODE the most repeated one. For salaries, the median describes the typical employee better.

=MODE(B2:B8)

Common mistake

If no number repeats it returns #N/A. It only works with numbers, not text.

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 MODE

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

MEDIAN and MODE

The average gets pulled by extreme values. MEDIAN is the middle value of the sorted list and MODE the most repeated one. For salaries, the median describes the typical employee better.

Example=MEDIAN(B2:B8)MEDIANA = MEDIAN MODA = MODE

Step 1/2

The average (E2) is skewed by the director’s salary. In E3, calculate the median.

	A	B	D	E
1	Employee	Salary
2	Marisol	12000	Average	25071.4286
3	Fernando	13500	Median
4	Gabriela	12000	Mode
5	Hugo	15000
6	Daniela	12000
7	Óscar	16000
8	Director	95000
9

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

Frequently asked questions

What is MODE called in Spanish?: In Spanish Google Sheets it is MODA. The formula =MODE(B2:B8) is written =MODA(B2:B8) (or with commas under a Mexico locale).
Why does MODE 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 MODE mistake?: If no number repeats it returns #N/A. It only works with numbers, not text.