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.
How Rounding works in Microsoft Excel 2010
To see what I mean, check out these examples.
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.
Round a number to a given number of digits
=ROUND (number, num_digits)
number -- The number to round.
num_digits -- The number of digits to which number should be rounded.