What Is ROUND Google Sheets Function?
The ROUND Google Sheets Function rounds up a given number to the specified number of digits. It is one of the inbuilt Math functions, that helps users get the whole numbers or integer values, in a large dataset, instead of their decimal or fractional values. The Google Sheets ROUND Function has other two functions available in the group, which are, the ROUNDUP and ROUNDDOWN functions.
For example, consider the below table with the numeric value. Now, let us round up a number using the Round function.
Select cell B2, enter the formula =ROUND(A2,0) and press “Enter”.
We get the output shown above, i.e., the number rounded to its 0 place as 221.
Table of Contents
Key Takeaways
- The ROUND Google Sheets function rounds the selected numeric values according to the number of digits allotted in the argument and it always returns numeric values for valid data selection.
- The ROUND function group has two more functions (ROUNDUP and ROUNDDOWN functions).
- In the ROUND formula’s 2nd argument,
- Positive digits (1, 2, and 3) rounds the decimals in that location.
- Negative digits (like -1, -2, and -3) round the decimals according to the multiples of 10, 100, and 1000.
- ‘0’ rounds the number based on the nearest number.
ROUND( ) Google Sheets Formula
The syntax of the ROUND Google Sheets formula is:
The arguments of the ROUND Google Sheets formula are:
- value: It denotes the numerical value that we want to round up or down. It is a mandatory argument.
- [places]: It mentions the location or the place value at which the number is rounded. It is an optional argument.
The following table shows the digits and the reference with which the values are rounded.
| Digits | Result |
| 0 | Round to the nearest number |
| 1 | Round the 1st decimal number to the right |
| 2 | Round 2 decimal numbers to the right |
| 3 | Round 3 decimal numbers to the right |
| -1 | Round to the nearest 10 |
| -2 | Round to the nearest 100 |
| -3 | Round to the nearest 1000 |
How To Use ROUND Google Sheets Function?
We can use the ROUND Google Sheets Function in 2 ways, namely,
- Access from the Toolbar.
- Enter in the Worksheet Manually.
Method #1 – Access from the Toolbar 🡢
Choose an empty cell for output 🡢 select the “Insert” tab 🡢 click the “Function” option right arrow 🡢 click the “Math” option right arrow 🡢 select the “ROUND” function, as shown below.
The ROUND formula appears as shown below.
Select the argument values as cell references or cell rangeand press “Enter”.
Method #2 – Enter in the worksheet manually.
- Select an empty cell to display the output.
- Type =ROUND( in the chosen cell. [Alternatively, enter =R or =ROUND and click the ROUND function from the suggestions Google Sheets lists.]
- Enter the cell values or references as the argument values.
- Close the brackets and press Enter to obtain the logical results in the target cells.
Examples
We will consider some examples with the different values for the optional argument to understand the ROUND Google Sheets Function examples.
Example #1
Let us round values using the ROUND in Google Sheets to the nearest 0.
The steps to round the values to the nearest number using the ROUND formula are as follows:
Step 1: Select cell B2 and enter the formula =ROUND(A2,0), as shown below.
Step 2: Press Enter. We can see that the function has returned the value 325 in cell B2.
Step 3: Drag the formula from cell B2 to B4 using the fill handle to get the following output.
Example #2 – Using [places] value as (1)
Let us round values using the ROUND in Google Sheets using [places] value as (1).
The steps to round the values to the place 1 using the ROUND formula are as follows:
Step 1: Select cell B2 and enter the formula =ROUND(A2,1), as shown below.
Step 2: Press Enter. We can see that the function has returned the value 125 in cell B2.
Step 3: Drag the formula from cell B2 to B4 using the fill handle to get the following output.
Example #3 – Using [places] value as (-1)
Let us round values using the ROUND Google Sheets Function using [places] value as (-1).
The steps to round the values to the place -1 using the ROUND formula are as follows:
Step 1: Select cell B2 and enter the formula =ROUND(A2,-1), as shown below.
Step 2: Press Enter. We can see that the function has returned the value 70 in cell B2.
Step 3: Drag the formula from cell B2 to B4 using the fill handle to get the following output.
Example #4 – Using [places] value as (2)
Let us round values using the Google Sheets ROUND Function using [places] value as (2).
The steps to round the values to the place 2 using the ROUND formula are as follows:
Step 1: Select cell B2 and enter the formula =ROUND(A2,2), as shown below.
Step 2: Press Enter. We can see that the function has returned the value 174.99 in cell B2.
Step 3: Drag the formula from cell B2 to B4 using the fill handle to get the following output.
Example #5 – Using [places] value as (-2)
Let us round values using the Google Sheets ROUND Function using [places] value as (-2).
The steps to round the values to the place -2 using the ROUND formula are as follows:
Step 1: Select cell B2 and enter the formula =ROUND(A2,-2), as shown below.
Step 2: Press Enter. We can see that the function has returned the value 100 in cell B2.
Step 3: Drag the formula from cell B2 to B4 using the fill handle to get the following output.
Important Things To Note
- The ROUND function rounds the values both up and down to a specified digit. Other ROUND functions in the group include the ROUNDUP, whichrounds the values up andROUNDDOWN, which rounds the values down.
- If the number of digits mentioned in the second argument is –
- Higher than ‘0’, the function rounds the values to the right.
- Equal to ‘0’, it rounds to the nearest number.
- Lesser than ‘0’, the function rounds the values to the left. -1, -2 and -3 rounds the number based on the multiples of 10, 100, and 1000, respectively.
Frequently Asked Questions
We often forget in which category a function falls, here, the “ROUND” function. Then, we can insert the function as follows:
Choose an empty cell 🡢 select the “Insert” tab 🡢 click the “Function” option right arrow 🡢 click the “All” option right arrow 🡢 select the “ROUND” function, as shown below.
However, as always, entering the function manually is the best way to avoid confusion.
A few reasons the Google Sheets ROUND function may not work are:
• The numeric value selected is already a whole number or an integer.
• The cell references selected is a text value, alpha-numeric, empty or a fraction.
Alternatively, we can find the function icon to insert the ROUND function by following the path shown below.
• Choose an empty cell 🡢 click the “More” option represented by the three vertical dots at the end of the toolbar, as shown below.
• A list of icons appears when we click the “More” option. Here, click the “Functions” icon, as shown below.
• Here, click the “Function” option 🡢 click the “All” option right arrow 🡢 select the “ROUND” function, as shown below.
Download Template
This article must help understand Round Google Sheets Function with its formulas and examples. You can download the template here to use it instantly.
Recommended Articles
Guide to ROUND Google Sheets Function. Here we learn its formula & use it to round numeric values with examples and working template. You can learn more from the following articles. –
Sentence Case In Google Sheets
Leave a Reply