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:

- 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:

#### 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.

#### More basic math formulas in Google Sheets:

- Addition
- Subtract
- Multiply
- Divide
- Exponents
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- FREQUENCY
- GROWTH Function
- Transpose Data
- SORT Function
- How To Multiply
- How To Divide
- How To Subtract
- Percentages
- SUMIF
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Trimmean
- Sum Columns or Rows
- Sumif
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula