How To Round In Google Sheets
If unnecessary decimal places in your data are causing rounding errors in calculations or making your sheet harder to read easily, the ROUND formula may be the solution you’re looking for.
With the ROUND formula, you can round numbers to a specified number of decimal places according to standard rules.
Using the ROUND Formula
The ROUND formula takes two input parameters:
- The first is the number you want to round.
- The second is the number of decimal places you want to round to.
If you don’t include the number of decimal places, the formula will default to zero decimal places.
Here’s how to use it:
Select the cell you want the rounded number to appear in “=ROUND(” to start typing the ROUND formula
Click on the cell that contains the number you want to round to add a reference to that cell to your formula
If you want to specify the number of decimal places, type a comma (,) to separate the parameters, then the number of decimal places to round to
Hit enter to finish your formula:
The rounded number will now appear in the cell
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to round in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
Get more Google Sheets stuff
Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.