Rounding numbers in Google Sheets

The ROUND function will let you round your cells to the nearest decimal place of your choosing. Learn how to do so with two methods.


Rounding numbers in Google Sheets Step 1

The first technique is to use the function =ROUND(Cell).

This will round your numbers to the nearest ones place.

From there you can simply click and drag the function throughout all of your numbers

How to round cells in Google Sheets Method 1b

From there simply click and drag the function throughout the rest of your column.

"=ROUND(Cell, Tens-Place)"

Rounding numbers in Google Sheets Method 2
If you feel like getting fancy with it, or you need to round your value to a different decimal, try this formula. 

In the example above, =ROUND (B6, -3) means that you will round 1325.343 to the nearest 10^3 spot, meaning increments of 1000. That being said, the yield of cell C6 will be 1000.

If I wrote =ROUND (B6,2) that would round the number to the nearest hundredths place (10^-2). That would be 1325.34

Tool Ribbon

Rounding numbers in Google Sheets Method 3

one final honorable mention would be the round up/down tools in the top menu toolbar. the one on the left removes decimals, while the one to to right adds decimals.

It will have the same effect as those previous functions, and I personally prefer it, because it is way quicker and easier than the other two. Also, make sure that you highlight all of the cells that you want to round up or down.

And there you have it; that is how you round numbers in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!