ROUND
Rounds a number to the number of decimal places you need, using the usual school rule: prices to cents, percentages to whole numbers.
ROUND(number, num_digits)- number
- What to round: a number, a cell or a formula like B2*1.2.
- num_digits
- How many digits to keep after the decimal point: 2 keeps cents, 0 gives a whole number, −3 rounds to thousands.
Return value
The number rounded to the given number of decimal places. With 0 digits you get a whole number.
Examples
Price with markup, to the cent
fx
A
B
C
D
1
2
3
4
5
6
7
Product
Base price, $
With 20% markup, $
Keyboard
1249,99
Mouse
333,33
Mouse pad
87,45
Headphones
2916,67
Sheet1
Details
ROUND changes the value in the cell itself, not just how it looks. If a cell holds 1499.988, then after =ROUND(1499.988,2) it holds exactly 1499.99, and that is what goes into further calculations.
The second argument says how many digits to keep after the decimal point. 0 rounds to a whole number, and a negative number rounds to the left of the decimal point: −2 gives hundreds.
A 5 rounds away from zero: 2.5 becomes 3, and −2.5 becomes −3.
Common mistakes
- The Decrease Decimal button only hides digits on screen. The full number goes into calculations, and totals end up a cent off from what you see.
- The sum of rounded numbers may not match the rounded sum. Decide in advance where to round: in every row or only in the total.
- The second argument is missing: Excel won’t let you finish the formula. To round to a whole number, write 0 explicitly.
In Google Sheets
In Google Sheets, the second argument of ROUND is optional and defaults to 0.