How to Use the ROUND Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: ROUND rounds a number to a set number of decimal places. The formula is =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])

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
1Value
299.44
31234
=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

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.

Hint: places is 1.

Exercise 2: Nearest hundred

Write a formula that rounds the number in A3 to the nearest hundred.

Hint: use a negative number of places.

What to learn next

Syntax and rules in this guide were checked against Google's ROUND help page. See all guides.