There are a few ways to dealing with rounding in Excel.
ROUND function
ROUND(number, num_digits) requires two inputs. The number is be rounded (normally a reference to a cell with a number in it, or a calculation) and the number of digits to round to. This can be entered as a positve number (will round to that many decimal places), zero (will round to no decimal places) or a negative number (will round to the left of the decimal place). Some examples will make it clearer.
In the first example above, we have specified to round to 2 decimal places.
In the second example we have specified to round to 1 decimal place.
In the third we have rounded to no decimal places.
In the fourth example, we have shown the value to the nearest 10, but putting -1 in the num_digits input.
And lastly, we have rounded to the nearest 100, by putting -2 in the num_digits input.
Do also note that the way you display the number can be different to the number you are rounding to, but should be consistent. For example, don’t round to 1 decimal place and then display three decimal places as this implies a level of precision that is not acccurate.
ROUNDDOWN, ROUNDUP
There are another two rounding functions with are worth mentioning.
Same inputs for these two as the ROUND function.
Again, some examples will help us.
In the first example above, we have rounded down, so the number is different to what we got with just the ROUND function.
In the second example, we have rounded up, so in this case, that is no different to what we got with ROUND.
Example three and four, using ROUNDDOWN, gives us a different result from the ROUND function.
Example five, ROUNDUP, gives us a different result to the ROUND function.
MROUND
Lastly, it is worth mentioning MROUND. This one is a bit more difficult to get your head around.
MROUND(number, multiple) This time, the inputs are number (same as before) and multiple. So, the number will be rounded to the closest multiple of the supplied input.
In the first example above, we have rounded to the nearest 0.2, so the number has rounded down.
In the second example, we have rounded to the nearest 0.5, so again, the number has rounded down.
Example three, we have rounded to the nearest 5, again rounded down in this case.
Example, four is rounding to the nearest 50. This has resulted in the number rounding up.
Example five, rounding to the nearest 20. This has resulted in the number rounding down.
Be aware that all these functions are different to showing a given number of decimal places in the cell using the number formatting. That will only effect what you see in the cell but leave the number in the background unchanged. Using the rounding functions, changes the actual number in the cell, not just what you see.
Now, you should be about to apply the correct rounding to your numbers!