ROUND Excel Function

Typically, the ROUND function is used in Excel to round up the numerical data according to the number of digits assigned to round the values.

The ROUND function formula is =ROUND(number, num_digits)

The steps used to find the rounded values in Excel are:

● Select an empty cell to display the result.
● Type the formula =ROUND(….
● Select the cell with the value along with the number of digits.
● Press ENTER.

For example, consider the below table with the value 789.0912 in cell A1. Now, let us learn how to use round function in excel to round up the number. 



The steps used to obtain a rounded value in Excel are as follows:

Step 1: First, we must select an empty cell to display the result. So, let us select cell B1.

Step 2: Next, enter the formula =ROUND( in cell B1.
For the first argument, we should select the cell that contains the number. So, let us select cell A1.

Step 3: Then, we need to specify the digit to round the values. 
In our example, let us round the first decimal number. So, type ‘3’ in the second argument.

So, the complete formula is =ROUND(A2,3).



Step 4: Now, press Enter.

In just a few steps, we can see that the value 789.0912 is rounded as 789.091.



❖ Therefore, we can use Round Excel function to get rounded values.

We can manually write the formula or use the following steps to use ROUND Excel Function;

1. To begin with, select the cell which has the number.
2. Then, choose the Formulas tab.
3. Next, click on the Math & Trig option from the Function Library group.



4. And, select the ROUND option.



5. In some time, the Function Arguments window pops up.
6. Here, enter the value in the Number and Num_digits as the number of arguments. 
7. Finally, click OK.