Thread: rounding again
View Single Post
  #1   Report Post  
Alex
 
Posts: n/a
Default rounding again

Sorry, I've finished the previous posting. Jason gave a great formula. Thanks
very much.

But, I've just found two exceptions.

When it's 28.50 it gives us 28.45 but we need the same 28.50,
and when it's 30.45 it gives us 30.50 but we need the same 30.45.

Could we fix it somehow?

Thanks
--------------------------------------
=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.