AVERAGE in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | AVERAGE | PROMEDIO |
| Syntax | =AVERAGE(number1, [number2], ...) | =PROMEDIO(number1; [number2]; ...) |
| Example | =AVERAGE(B2:B20) | =PROMEDIO(B2:B20) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What AVERAGE does
Returns the arithmetic mean of numbers or ranges. Example: Averages the values in B2:B20.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
Empty cells and text are ignored, but zeros count, which can pull the average down.
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with AVERAGE?
Empty cells and text are ignored, but zeros count, which can pull the average down.