How To Round In Google Sheets

In this tutorial, you will learn how to round in Google Sheets.

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.

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.