How to Use the ROUND Function in Google Sheets
=ROUND(value, [places]). With no places it rounds to a whole number, and a negative number rounds to the left of the decimal point.
ROUND vs formatting
Changing a cell's number format only changes how a value is displayed. The stored value keeps all its decimals. ROUND changes the value itself, which matters when you add up prices or percentages and want the totals to match what people see.
ROUND syntax
=ROUND(value, [places])
value: the number to round.places(optional): how many decimal places to keep. The default is 0. A negative number rounds digits to the left of the decimal point.
Per Google's help page, ROUND looks at the digit right after the place you are rounding to. If that digit is 5 or higher, the number rounds up. Otherwise it rounds down. "Up" and "down" refer to magnitude, so the sign does not change the rule: 2.5 rounds to 3 and -2.5 rounds to -3.
A step-by-step example
Cells A2 and A3 hold two numbers.
| A | |
|---|---|
| 1 | Value |
| 2 | 99.44 |
| 3 | 1234 |
=ROUND(A2, 1)
This returns 99.4. Here is why: the digit after the first decimal place is 4, which is below 5, so it rounds down. With no places, ROUND goes to a whole number:
=ROUND(A2)
This returns 99.
Round to the nearest ten or hundred
A negative places value rounds to the left of the decimal point. -1 rounds to tens and -2 to hundreds:
=ROUND(A3, -2)
This returns 1200: the digit after the hundreds place is 3, so 1234 rounds down to 1200.
Related functions
Google's page lists ROUNDUP, ROUNDDOWN, MROUND, TRUNC, INT, FLOOR and CEILING for other kinds of rounding. Use ROUNDUP or ROUNDDOWN when you always want to go in one direction.
Common mistakes
- Relying on formatting. A cell shown as 99.4 can still hold 99.44.
- Mixing up the sign of places. Positive places go right of the decimal point, negative places go left.
- Rounding too early. Round the final result, not every step, to keep totals accurate.
Try it yourself
Use the numbers above (A2 and A3). Type your formula into the box, starting with =, then press Check.
Exercise 1: One decimal place
Write a formula that rounds the number in A2 to one decimal place.
Exercise 2: Nearest hundred
Write a formula that rounds the number in A3 to the nearest hundred.
What to learn next
- SUMPRODUCT: multiply two ranges and add the results.
- AVERAGE: find the mean of a range.
- MIN and MAX: find the smallest and largest values.
Syntax and rules in this guide were checked against Google's ROUND help page. See all guides.