How Rounding works in Microsoft Excel 2010. Rounding in Excel refers to reducing the number of digits in a number to make it easier to work with. Even seasoned Excel professionals get caught out by this one, and end up scratching their head while they try to figure out why their calculations don’t work out as expected.
To see what I mean, check out these examples.
Summing Up
The Microsoft Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point.
Purpose
Round a number to a given number of digits
Syntax
=ROUND (number, num_digits)
Arguments
number – The number to round.
num_digits – The number of digits to which number should be rounded.