Round function, how to use rounded functions in Excel

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.

1. These are the most basic functions in Excel that you need to understand
2. How to use ConcateNate function on Excel
3. How to use AVERAGEIF function in Excel

Instructions for using Round function in Excel

Round function in Excel has syntax = ROUND (number, n) .

Inside:

1. Number is the number to be rounded.
2. N is an argument that can be negative or positive.

With argument N we will have a number of different cases.

1. If N = 0 then we will round to the nearest integer. For example rounding numbers ROUND (9.23.0) = 9
2. If N> 0, the number will be rounded to the specified decimal place. Such ROUND (21.25464.5) = 21.25. If N = 1 takes 1 odd number, n = 2 takes 2 odd numbers, .
3. If N For example: ROUND (23.23434, -1) = 20. If N = -1, rounded up to tens, N = -2 rounded to hundred and N = -3 to thousands .

We will do so with the score table below. Let's round numbers to 2 decimal places.

Round function, how to use rounded functions in Excel Picture 1

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.

Round function, how to use rounded functions in Excel Picture 2

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:

1. How to combine 2 columns Full name in Excel does not lose content
2. How to use SUMPRODUCT function in Excel
3. How to combine Sumif and Vlookup functions in Excel

I wish you all success!