3 Ways to Round Numbers in Google Sheets

how to round numbers in Google Sheets

Here’s a guide on how to round numbers in Google Sheets using the ROUND function and its variants (RUNDOWN, ROUNDUP). Spreadsheet is an efficient and easy-to-use tool when you need to perform mathematical calculations using different mathematical formulas and functions.

Related: How to Freeze Rows or Columns in Google Sheets

Google Sheets is a free cloud-based spreadsheet application and a reliable alternative to Microsoft Excel. Despite being a cloud-based app, Google Sheets is still a pretty good tool.

On tutorials Here, I will talk about how you can use Google Sheets to round numbers as per your requirement.

Rounding Functions in Google Sheets

When working with numbers, you may need to round decimal numbers to a fixed number. In Google Sheets, there are three functions to round numbers, as you can see below:

Let’s first see how the ROUND function works:

ROUND

ROUND(value, [places]) takes two arguments, the first of which is the number you want to round or the cell reference. The second argument is another number indicating the number of decimal places you want to be rounded.

The ROUND function rounds a number to either the base value or the ceiling value depending on the original number. Let’s apply this function to some numbers.

Step 1: Launch Google Sheets, start with a new blank sheet, rename it to “round” and prepare the data as shown in the image below.

how to round numbers in Google Spreadsheet-1

Step 2: Click in cell D7, then click the “Insert” menu and hover over Function > Math > ROUND , then click the ROUND function. Or just type in the formula bar “=ROUND(“

how to round numbers in Google Spreadsheet-2

Step 3: Next enter the number to be rounded directly or click the cell containing the number (i.e. D6) to get the cell reference number and press enter.

Step 4: D7 will now contain the number 12, the floor from the original number. This is because “=ROUND (D6)” is the same as “=ROUND (D6, 0)” which is a zero after the decimal. Applying the same formula in E7 to the value in E6 gives 13 ceilings from the original number.

how to round numbers in Google Spreadsheet-3

Step 5: In cell D8, use the ROUND function to round the decimal part to one digit after the decimal with the command “=ROUND(D6, 1)” yielding 12.5. For the value at E6, the result is 12.6.

how to round numbers in Google Spreadsheet-4

Step 6: In cell D9, use the ROUND function to round the decimal part to two digits after the decimal. i.e. “=ROUND(D6, 2)” so there is no change because the number already has two digits after the decimal. Likewise with the contents of the E6.

how to round numbers in Google Spreadsheet-5

Related: How to Insert Images Into Cells In Google Sheets

ROUNDDOWN

ROUNDDOWN(value, [places]) is similar to the ROUND function but as the name suggests, it rounds a number to a base value. Follow these steps to apply it:

Step 1: In Google Sheets add a new sheet, rename it to ROUNDDOWN, and prepare the data as before.

how to round numbers in Google Spreadsheet-6

Step 2: Select cell D7 and enter the function “ROUNDDOWN” from Insert > Function > Math > ROUND or type in the formula bar “=ROUNDDOWN(“

how to round numbers in Google Spreadsheet-7

Step 3: Repeat the same experiment as before with the ROUNDDOWN function. “=ROUNDDOWN(D6)” returns 12 in D7. For the value at E6, this gives the same result as the value in both cases.

how to round numbers in Google Spreadsheet-8

Step 4: In cell D8, use the ROUNDDOWN function to round the decimal part to one digit after the decimal. i.e. “=ROUND(D6, 1)” returns 12.4. This rounds the value in E6 to 12.5.

how to round numbers in Google Spreadsheet-9

Step 5: In cell D9, tell the ROUND function to round the decimal part to two digits after the decimal. i.e. “=ROUND(D6, 2)” which results in no change to the original value. Similarly, the value at E6 is also unchanged.

how to round numbers in Google Spreadsheet-10

Related: How to Use a Slicer in Google Sheets

ROUNDUP

ROUNDUP(values, [places]) is the inverse of the ROUNDDOWN function and rounds the number represented by the second argument to its ceiling value. Let’s repeat the same example in the same cell to see the difference.

Step 1: In Google Sheets add a new sheet and rename it to roundup.

Step 2: Rounding the value at D7 gives 13 with “=ROUNDUP (D6)” and Repeating for E6 also gives 13 at E7 the ceiling value in both cases.

how to round numbers in Google Spreadsheet-11

Step 3: In cell D8 to round up to one digit after decimal use type “=ROUNDUP(D6, 1)” returns 12.5. This rounds the value at E6 to 12.6 at E8.

how to round numbers in Google Spreadsheet-12

Step 4: In cell D9 to round up to two digits after the decimal type “=ROUNDUP(D6, 2)” returns 12.45 without change. Similarly, the value at E6 is also unchanged.

how to round numbers in Google Spreadsheet-13

In this article I have shown how you can use the main ROUND function and its variants (RUNDOWN, ROUNDUP) to easily round numbers in Google Sheets.

That’s how to round numbers in Google Sheets. I hope this article helped you! Thank you for visiting and don’t forget if you find this article useful, please share it with your friends too.

Leave a Reply

Your email address will not be published.