To round in Google Sheets, type =ROUND(value, places) into a cell, for example =ROUND(A2, 1) to keep one decimal place. Leave out places to round to a whole number. If you always need to round up or down instead, use ROUNDUP or ROUNDDOWN, which work the same way.
Rounding is one of those jobs that looks trivial until a report adds up wrong. Google Sheets gives you a whole family of rounding functions, and picking the right one matters more than people think. Here's how ROUND works, when to reach for its cousins, and the one setting that fools almost everyone.
How to use ROUND, step by step
- Click the empty cell where you want the rounded result.
- Type =ROUND( and then click the cell holding the number, for example A2.
- Type a comma and the number of decimal places you want, such as 1.
- Close the bracket so it reads =ROUND(A2, 1), then press Enter.
- Drag the small square at the corner of the cell down the column to round the rest of your list.
Google's own example is =ROUND(99.44, 1), which keeps one decimal place. If you leave the second part out entirely, as in =ROUND(A2), Sheets rounds to a whole number, because places is 0 by default.
How Sheets decides whether to go up or down
ROUND follows standard rules. Sheets looks at the digit just to the right of the place you're rounding to. If that digit is 5 or more, it rounds up. If it's 4 or less, it rounds down. Google points out this happens irrespective of sign, so negative numbers follow the same rule on the digit.
The rounding family and when to use each
| Function | What it does | When I'd use it |
|---|---|---|
| ROUND | Rounds up or down by the standard rule | Tidy totals for a report |
| ROUNDUP | Always rounds up to the next step | Working out how many boxes or sessions you need |
| ROUNDDOWN | Always rounds down | Counting only complete units |
| MROUND | Rounds to the nearest multiple of another number | Rounding minutes to the nearest 5 |
| INT | Rounds down to the nearest whole number | Dropping the decimals from a count |
| TRUNC | Chops off digits without rounding | Shortening a number exactly as stored |
| FLOOR and CEILING | Round down or up to a multiple you choose | Time slots and pack sizes |
ROUNDUP and ROUNDDOWN take the same two inputs as ROUND, so =ROUNDUP(A2, 0) gives you the next whole number every time. That's the one I use for planning, because if a job needs a little over 3 batches, you need 4 batches, not 3.
Rounding to tens or hundreds with a negative number
This is the trick most guides skip. The places part can be negative. Google's help page says a negative value rounds at that many digits to the left of the decimal point. So =ROUND(A2, -1) rounds to the nearest ten and =ROUND(A2, -2) rounds to the nearest hundred. It's perfect for summary slides where nobody needs the exact number down to the unit, just the rough size.
The catch: formatting isn't rounding
Here's what trips people up. Sheets has buttons in the toolbar to show fewer decimal places. They change how the number looks, not the number itself. The cell still holds every digit, so if you add up a column of numbers that only look rounded, the total can come out slightly different from what you'd get adding the displayed values by hand.
If you want the stored value to change, use ROUND (or one of its relatives) in a formula. If you only want a neater display and the maths underneath should stay exact, the decimal buttons are fine. Knowing which one you've used saves a lot of head scratching when two reports disagree.
Rounding inside another formula
You don't need a separate column. You can wrap ROUND around a calculation, for example =ROUND(A2/B2, 2) to divide and keep two decimal places in one go. Do the maths first inside the brackets, then the rounding happens on the result. It keeps your sheet shorter and stops someone copying the unrounded helper column by mistake.
Want AI doing the heavy lifting in your marketing?
I build the systems that handle the boring 80 percent, so you get your week back. Done properly, with the human kept in.
Common mistakes
- Rounding too early. If you round each line and then add them up, small differences add up too. Round the final total instead, unless the rules of your report say otherwise.
- Mixing up ROUNDDOWN and INT on negative numbers. INT rounds down to the nearest integer that is less than or equal to the number, so it moves negative numbers further from zero. Check a negative value before relying on it.
- Typing the result over the formula. Once you paste a number over the formula, it no longer updates when the source changes.
My take
For most small-business sheets, ROUND for reports and ROUNDUP for planning covers nearly everything. Use the negative places trick for summary numbers, and remember that the decimal buttons only change the look. For the sums that come before the rounding, see my guides to adding up a column in Google Sheets and multiplying in Google Sheets.
Frequently asked questions
What is the formula to round in Google Sheets?
Use =ROUND(value, places), for example =ROUND(A2, 2) for two decimal places. Leave places out to round to a whole number.
How do I always round up in Google Sheets?
Use ROUNDUP, for example =ROUNDUP(A2, 0). It always rounds up to the next step rather than following the 5 or more rule.
Can Google Sheets round to the nearest ten?
Yes. Use a negative number of places, such as =ROUND(A2, -1) for the nearest ten or -2 for the nearest hundred.
Why does my total not match the rounded numbers?
You probably used the decrease decimal button, which only changes the display. The cells still hold the full values, so use ROUND if you need the stored number to change.
What's the difference between TRUNC and ROUNDDOWN?
Both drop digits, but TRUNC simply cuts them off, while ROUNDDOWN rounds down to the next valid increment. For positive numbers they usually give the same answer.
