The ROUND function in Excel
ROUND tidies a number to a set number of decimal places.
What ROUND does
Positive digits round to decimal places, zero rounds to a whole number, and negative digits round to the left of the decimal point, so -1 rounds to the nearest ten. The number you pass in can be another formula, which is how it is most often used.
Syntax
=ROUND(number, num_digits)
- number
- The number to round. This can be a cell, a value or another formula.
- num_digits
- How many decimal places to keep. Use 0 for a whole number and -1 for the nearest ten.
Worked example
| A | B | |
|---|---|---|
| 1 | Item | Price |
| 2 | Pen | 12.45 |
| 3 | Pad | 9.99 |
| 4 | Ink | 15.20 |
| 5 | Clip | 11.10 |
| 6 | Average | 12.2 |
The average is 12.185. Rounded to one decimal place it is 12.2.
Now you try
A fresh exercise every time. Press Another exercise as often as you like.
Where you will use it
Finance
Round prices and tax so totals match invoices.
Sales & Ops
Round averages for a report.
Data cleanup
Remove stray decimals from imported numbers.
Common mistakes
- Using number formatting instead of ROUND. Formatting changes how a number looks but not its value, so totals can look off by a penny.
- Rounding too early. Round the final result, not each step along the way.
- Mixing up ROUND with ROUNDUP and ROUNDDOWN, which always go up or always go down.
The ROUND course
- 1Tidy up decimalsFree practice belowPractise
- 2Round up and downMembers lesson
- 3Round to the nearest 5Members lesson
- 4Price rounding rulesMembers lesson
- 5Currency and tax mathsMembers lesson
Common questions
What is the difference between ROUND and formatting?
Formatting only changes what you see. ROUND changes the stored value.
How do I round to the nearest ten?
Use a negative number of digits, for example =ROUND(A1,-1).
Related functions
Unlock every lesson
Every function has a free lesson. Members get all the lessons, fresh exercises every time and the weekly leaderboard. £7 a month or £49 a year, and you can cancel at any time.