Use the ROUND function in which you specify the number of
decimal places you want, e.g
=ROUND(123.4446, 2) = 123.44
Kevin Beckham
-----Original Message-----
Hello!!
I have to make rounding on some numbers but the rule of
my rounding
would be these:
1)if the number has the value "4" in the 3rd decimal
position leave the
number rounded on second decimal. Example
if number is 8932,2341 the rounded number would be
8932,23.
2)if the number has the 3rd decimal position greater
than "4", round
off for excess. Example if number is 62725,1591 the
rounded number
would be 62725,16.
I don't know how make this in excel because the default
rounding
doesn't work with specifical number on a specifical
decimal position.
Someone can tell me how solve this problem???!?!?
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
.