=ROUNDUP(A1/0.05,0)*0.05
HTH
Jason
Atlanta, GA
-----Original Message-----
I need to do the following rounding in the column where
the data obtained
from calculations:
61.4111 to 61.45
68.632 to 68.65
85.85015 to 85.85
33.68 to 33.70
So, the second digit should be 0 or 5. If the second
digit was 5 it should
remain 5, if 0 and <= 5 and it should be 5, if 5 the
second digit should
be 0 but the first digit will be by 1 more.
Could anybody advise what kind of formula could I use
here?
Thanks in advance.
.
|