ROUND in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | ROUND | REDONDEAR |
| Syntax | =ROUND(number, num_digits) | =REDONDEAR(number; num_digits) |
| Example | =ROUND(A1,2) | =REDONDEAR(A1;2) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What ROUND does
Rounds a number to a number of digits. Example: Rounds A1 to 2 decimal places.
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
A negative second argument rounds to tens, hundreds and so on.
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 ROUND?
A negative second argument rounds to tens, hundreds and so on.