Rounding - Excel
Rounding to decimal places
=ROUND(#,decimal places)
e.g. =ROUND (2750.21,0) = 2750
Rounding thousands, millions etc
e.g. =ROUND (2750.21,-3) = 3000
Rounding a number to the nearest desired multiple
=MROUND(24,5) = 25
No comments:
Post a Comment