ROUND function
ROUND rounds a number to the number of digits you choose, with halves going away from zero. Use it to change a total to its real value, not just its display, since formatting only hides decimals.
Example
Read it as a sentence: round 2.567 to 2 decimal places, which gives 2.57.
A
B
C
D
1
2.57
2
3
Syntax
ROUND(number, num_digits)
-
number(required) - The value to round.
-
num_digits(required) - Decimal places to keep; 0 for whole numbers, negative to round tens, hundreds and so on.
Returns: The number rounded to the chosen precision.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ROUND(2.345,2) | 2.35 | 2.345,2 |
=ROUND(-2.345,2) | -2.35 | -2.345,2 |
=ROUND(2.5,0) | 3 | 2.5,0 |
=ROUND(-2.5,0) | -3 | -2.5,0 |
=ROUND(1234,-2) | 1200 | 1234,-2 |
=ROUND(2.345,1.9) | 2.3 | Digits 1.9 truncates |
=ROUND("abc",1) | #VALUE! | Text |
=ROUND(Data!E4,1) | #DIV/0! | Error cell |
The Data sheet these formulas read
A cell that starts with = holds that formula.
E
1
5
2
abc
3
TRUE
4
=1/0
Data
Watch out for
- Formatting only hides decimals; ROUND actually changes the value.
- ROUND(1250,-2) gives 1300.
Where it works
- Excel
- ROUND is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .