If you often have to calculate the data on Excel, calculating the average result will inevitably be the case that the result is a decimal number with odd numbers after a comma, or a period. Leaving multiple numbers after the comma will make the data sheet difficult to see, difficult to calculate and not professional. Therefore, rounding up in Excel is necessary to make the table more clear.
If you don't know how to use the Round function in Excel or haven't used the Round function yet, follow the following article of Network Administration.
Instructions for using Round function in Excel
Round function in Excel has syntax = ROUND (number, n) .
Inside:
With argument N we will have a number of different cases.
We will do so with the score table below. Let's round numbers to 2 decimal places.
In the box to enter the rounded score results, we enter the formula = ROUND (C2,2) and press Enter.
In which C2 column is the average of students. 2 is to take only 2 numbers to the right of the decimal point, rounded up to 2 numbers after the comma. In case N
Immediately the result will give the score rounded to the second number after the decimal point. Scroll down to enter the score for students.
With the Round function in Excel, users will be easy to round the data, more neatly the spreadsheet instead of leaving multiple numbers behind the decimal. When rounding, viewers will easily follow the Excel data sheet, which you can also calculate more quickly.
See more:
I wish you all success!
ncG1vNJzZmismaXArq3KnmWcp51kv7DBzZ1kn62emMGqu81mn6ivXam8bsHSnmSrp6WjsaawjJ%2Bsp5uknryvv4yipWadqJiyrQ%3D%3D