Excel function · Statistics
ROUND
Rounds a number to a given number of decimal places.
What it does
ROUND rounds a number up or down to the nearest value with the digits you ask for. Unlike number formatting, it changes the stored value, so later sums use the rounded number.
Syntax
=ROUND(number, num_digits)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,
Arguments
- number
- The number to round, usually a cell or a calculation.
- num_digits
- How many decimal places to keep. 0 gives a whole number; -1 rounds to tens, -2 to hundreds.
Example
How do you round 12.3456 to two decimal places?
| A | B | |
|---|---|---|
| 1 | Exact | Rounded |
| 2 | 12.3456 | 12.35 |
The formula in B2:
=ROUND(A2,2)Result: 12.35
The third decimal is 5, so the second goes up: 12.3456 becomes 12.35.
Common mistakes
- Relying on formatting instead. A cell can show 12.35 but still hold 12.3456, which shows up in totals.
- Expecting it to always round up. Use
ROUNDUPorCEILINGfor that.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | ROUND | , |
| Deutsch | RUNDEN | ; |
| Français | ARRONDI | ; |
| Español (España) | REDONDEAR | ; |
| Español (México) | REDONDEAR | , |
| 日本語 | ROUND | , |
| 한국어 | ROUND | , |
| 繁體中文 | ROUND | , |
| ไทย | ROUND | , |
| ខ្មែរ | ROUND | , |
| Tiếng Việt | ROUND | ; |