Rounding Numbers To Nearest Decimal Place

Short tutorial that explain you on rounding numbers to nearest decimal place.

Round To Nearest Decimal / Integer

You can use the positive number count in the Round Function to round the number to the nearest decimal place you mention. For instance, to round a number to two decimal place, use 2 as number digit. Here is a short tutorial on it with example.

Rounding Numbers To Nearest Decimal Place
Let us consider an example where you have to round number to nearest 2 decimal place.
Step 1: Enter the set of decimal values. Select a cell to get the resultant value. Type the function =ROUND( and select the first cell to which you are going to round the value. Enter a comma symbol (,) followed by the number digit. Here we have specified to round to the two decimal place. Close the Parenthesis.
Rounding Number With Postive Digit Step1
Step 2: Click on the enter button to get the resultant value.
Rounding Number With Postive Digit Step2
Step 3: Select the resultant cell and drag the mouse pointer from the right corner until the field you need. You can see the numbers are rounded to 2 decimal places.
Rounding Number With Postive Digit Step3