How To Round In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

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:

1. The first is the number you want to round.
2. 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:

Step 1

Select the cell you want the rounded number to appear in “=ROUND(” to start typing the ROUND formula

Step 2

Click on the cell that contains the number you want to round to add a reference to that cell to your formula

Step 3

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

Summary

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.