Decimal numbers can make your data difficult to read. We usually consume numerical data in whole numbers, and hence, having decimals isn’t necessary for every data. Also, decimals can make your data look asymmetric. So, we need to understand how to round in Google Sheets to get the custom number format of whole numbers that enhances data readability.

Google Sheets provides you built-in rounding functions to round off unnecessary digits. You can opt for any of these functions depending on your requirements. When using the IF function in Google Sheets, you can nest it to the ROUND function to ensure you get clean calculations without any decimal numbers.

The Standard Rounding Rule

Coming to the standard rule, the digit to the right side of the rounding digit should be equal to or greater than 5. If that is the case, the rounding digit will be incremented by 1, and the integer to its right will be cut out.

If the significant digit to the right isn’t greater or equal to 5, the rounding digit will be intact, but all numbers after the rounding number will be cut out.

Let’s say you have a number 2.16, and you need to round it off by 1 decimal. Here, the rounding digit is 1, and the digit to its right is 6. Since 6 is greater than 5, the rounding digit will be incremented by 1. The result will be 2.2.

Another example. Let’s say we have a number 2.246, and we need to round it off by 1 decimal place; the rounding digit is 2 because it’s in the first place after the decimal point. To the right of 2 is 4, which is less than 5. Hence, the rounding digit remains the same. Instead, the result will be 2.2, which cuts out the decimal digits 4 and 6 from the original number.

A Quick Guide On How To Round In Google Sheets

Reading decimal number values can be a nightmare, which is why you need rounded numbers to ease the job of data comprehension. So, you can choose to skip it by getting to know all about the various types of ROUND functions.

How To Use The ROUND Function

The syntax of the ROUND formula function, as given below, is pretty simple to comprehend.

=ROUND(value,[places])

Here, value is the number you wish to round off. This can be the actual numeric value or the cell reference in which the particular value is placed.

Places is the number of digits or decimal points upto which you want to round off the value. This is an optional value; the default value for this parameter is 0.

Consider these sample numbers; we need to round off these numbers upto the places as specified in the Decimal Places column.

Sample sheet
Sample sheet

Now, apply the function as given below in cell C1 in the Google sheet. When you start typing the formula, you can click on the Auto-suggest box and enter the function syntax in the cell.

=ROUND(A2,3)
Enter the function
Enter the function

Press the Enter key to obtain the result.

View the rounded off numbers
View the rounded off numbers

Now, let’s study the result of each number in detail.

2) In the number 2.46, we need to know how to round in Google sheets by 1 decimal place. Here, the rounding digit is 4 since it’s the first digit after the decimal point. The digit to the right of 4 is 6. Again, 6 is greater than 5, so the rounding digit and the one next to it are rounded off to 5. The answer becomes 2.5.

3) In the number 6.164, we have to round off the number by 2 decimal places. So, 6 is the rounding digit here. However, the number to the right of 6 is 4. So, the number 6 will remain intact, but 4 will be rounded off and cut out.

4) In the number 7.32, we had to round off the number by 1 decimal place. Here, 3 is the rounding digit. The digit to the right of 3 is 2. Hence, 3 remains intact, and 2 gets cut out. So, the final result is 7.3.

You can use the fill-down method in Google Sheets to obtain the result for all cells after calculating the result in the first cell. However, you must manually edit the ‘places’ value in the ROUND function for all records since you are using different place values for different numbers. That’s all the basics about how to round in Google Sheets.

ROUND Function With Negative Place Values

In the previous example, we saw how to round in Google Sheets using positive number values. Now, let’s take a look at how to round numbers in Google sheets when we input negative values.

For instance, if the place value in the rounding function is -1, the value will round to the nearest integer with a tens value. Similarly, if the Places value is -2, the number will round to the nearest integer with hundreds value.

Let’s look at this with an example.

These are the numbers that we have to round off with negative values.

Sample data
Sample data

To begin with, enter the formula with the negative value in the active cell.

=ROUND(A2,-2)
Enter the function in the active cell
Enter the function in the active cell

Once you press the result, you can see the answer in the selected cell, i.e., C2.

The round function result
The round function result

Now, let’s take 243.45 as a case in point. Here, we decided to do Google Sheets rounding up by -1, as specified in cell B2. So, the number was rounded off to its nearest digit with a tens value, i.e., 240.

The Places value for 2345.56 was -3, so the number was rounded off to its nearest thousand value, which is 2000. Likewise, the number 6423.164 was rounded off to its nearest hundreds value 6400, because we used -2 as the place value.

Now, let’s take another example. Suppose we have these two numbers, as shown in the sheet below. We have already calculated the results in this case.

Sample data
Sample data

The first number 564.98 has been rounded off to 560, while the second number 567.23 has been rounded to 570. Why are these two numbers different?

That’s because the Google Sheets ROUND function rounds off to the nearest tens, hundreds, or thousands value. Here, the nearest tens value(because we have -1 as the place value) for 564 is 560, so we get that as the answer. Meanwhile, the tens value for 567 is 570. Hence the function rounds off to 570.

Suppose both the numbers had a -2 decimal place value. What would be the answer for both?

The output for both numbers would be 600 because that is their nearest hundreds value. On the other hand, if a number was 523.87 with a -2 decimal value, the answer would be 500 since that is the closest hundreds value to the number.

How To ROUNDUP In Google Sheets

We have completed the basics of how to round in Google Sheets. Now, let’s take a look at its variant – the ROUNDUP function. The working principle of the ROUNDUP function is similar to the ROUND function, except that it always rounds off in the upward direction.

The syntax, too, is similar to the ROUND function.

=ROUND(value,[places])

Let’s consider this sample sheet from the first example.

 Sample sheet
Sample sheet

Apply the formula in the selected single cell as shown below. You can also enter the function in the formula bar.

=ROUNDUP(C2, 3)

Here’s how the result looks like.

Use the ROUNDUP function
Use the ROUNDUP function

Now, let’s compare these results to the Google Sheets ROUND function results. The first two numbers have the same results when we use both ROUND and ROUNDUP functions. Why is that so? Because both numbers are rounded upwards when both rounding functions are used.

Consider the third number 6.164. The result using the ROUND function was 6.16. However, the result after using the ROUNDUP function is 6.17. That is because ROUNDUP always rounds off numbers upwards.

ROUNDUP Function With Negative Place Values

ROUNDUP function can also be used for negative values. However, in contrast to what we saw in the ROUND function, the ROUNDUP function doesn’t round a number to its nearest tens, hundreds, or thousands value. It will always round up the number to its next greater value.

For instance, let’s consider this sample sheet from the Google Sheets ROUND function using negative numbers.

These are the numbers that we have to round off with negative values.

Sample data
Sample data

Enter the formula and press the Enter key to obtain the result

=ROUNDUP(A2, -1)
View the result
View the result

Now, compare the results of 243.45 using both ROUND and ROUNDUP functions. The result using the ROUND function was 240, while the ROUNDUP function result was 250.

Even when a negative number is used as a decimal place value, the ROUNDUP function will always round off the number upwards. That’s all about how to round in Google Sheets using the ROUNDUP function.

How To ROUNDDOWN In Google Sheets

We have studied the similarities and differences between the ROUND and the ROUNDUP functions. Now, let’s take a peek at the ROUNDDOWN function guide.

The ROUNDDOWN function works similarly to the ROUND function, except that it always rounds a number downwards. So, it is precisely the opposite of the ROUNDUP function.

Let’s see this sample sheet for example.

Sample sheet for how to round in google sheets
Sample sheet

Now, we have to use the ROUNDDOWN function for these numbers. Enter the formula given below.

=ROUNDDOWN(A2, 3)

Press Enter key to get the results.

View the results for how to round in google sheets
View the results

Now, let’s take a look at 2.46 from this sheet. The result after using the ROUND DOWN in Google sheets is 2.4. That’s because the number to the right of the rounding digit 4 is 6. Since that is greater than 5, the rounding will take place.

However, because we are using the ROUNDDOWN function, the result will become 2.4 and not 2.5. Had we used the ROUND function, the result would have been 2.5.

ROUNDDOWN Function With Negative Place Values

For instance, let’s take a look at this sample sheet.

Sample sheet for how to round in google sheets
Sample sheet

We have already seen the results for these same numbers when you use the ROUND function. Now, let’s see what the differences are when it comes to the ROUNDDOWN function.

Enter the formula in the selected cell as shown below.

=ROUNDDOWN(A2, -1)

Press Enter key to get the results.

View the result for how to round in google sheets
View the result

Let’s study the number 243.45. When it comes to negative decimal places, we don’t consider the rounding digit and what comes to its right side. Instead, we directly round off the number.

Since the ROUNDDOWN function is used with a decimal place -1, the tens value will be reduced. Hence, it comes down from 243.45 to 240.

Now, if you may have noticed, when we use the ROUND function for the same number, the answer is the same. Why does that happen?  Because while working with negative place values, the ROUND function rounds off to the nearest tens, hundreds, or thousands value.

243.45 is a number that satisfies both conditions for ROUNDDOWN and ROUNDUP functions. Hence, the answer remains the same.

If we change the number to 247.45, the ROUNDDOWN function will show the same result, i.e., 240. However, the ROUND function will show the result as 250. So, again, we see both rounding functions acting according to their respective standard rounding rules. That’s all about how to round in Google Sheets using the ROUNDDOWN function.

How To Use The MROUND Function

The MROUND function is different in contrast to the three functions we have seen earlier. Here, the number in question gets rounded to the nearest integer multiple of the value of the decimal place.

For instance, consider the number 214.678 in the image below. We need to round it off to 3 decimal places. So, the answer will be any number that is a multiple of 3 and closest to 214.678. The rounded number 216 ticks off both conditions.

Select the cell, C2 in this case, and enter the formula as shown below.

=MROUND(A2, 3)

Press the Enter key to obtain the result. You can use the fill-down method to calculate the remaining answers.

MROUND function for how to round in google sheets
How to use the MROUND function

Similarly, take a look at 222.888 in the fifth row. We have to round it off to 7 decimal places. So, the final result will be a number that is a multiple of 7 and closest to 222.888.

When contemplating how to round in Google Sheets, make sure you know how each complete function works and then choose one accordingly. We can also use the CEILING function and the FLOOR function to round numbers, but they work a tad bit different as compared to the rounding functions.

Final Thoughts On How To Round In Google Sheets

The ROUND function is used to round off decimal numbers in Google Sheets. Knowing how to round in Google Sheets allows users to keep datasets in whole integers and avoid issues related to readability. You can use all the ROUND functions on mobile. The steps of using it on mobile are similar to that of the PC.

The ROUND function and its variations are similar in many aspects. So, it’s essential to understand where they differ from each other. These differences may help you in selecting the proper function to round off numbers as per your needs and requirements. You can also use the ROUND function to round a number to its nearest hundreds value. However, this can be done only if the decimal place section in the function is negative.