U r thinking wats the pro thingy in "Round" formula....
Ok, m sure u wont think it after reading followings...
How do u round a number say "12345.67"?
Do u do round like...
=round(12345.67,0) where result is 12346, or
= roundup(12345.67,0) where result is 12346, or
= rounddown(12345.67,0) where result is 12345
ok, new thing, u can round like...
=round(12345.67,) where result is 12346, or
= roundup(12345.67,) where result is 12346, or
= rounddown(12345.67,) where result is 12345
i.e. without entering zero (0) after comma...
Nw u r thinking wat the hell... wat the pro thingy in it...
ok, tell me hw u round in hundreds ('00) or thousands ('000), if u wish to?????
Ok, dont think...
see, for rounding to, say 2 digits after decimal, v place 2 after comma,
same way to round, say 2 digits before decimal, v ll place -2 after comma...like...
=round(12345.67,-2) where result is 12300, or
= roundup(12345.67,-2) where result is 12400, or
= rounddown(12345.67,-2) where result is 12300...
0 comments:
Post a Comment