rounding again

[Guest]

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

 

[Guest]

Sorry, guys.
I've analyzed it ones again. It looks like everything is Ok.

Thanks

 

[N Harkawat]

use
=CEILING(--(LEFT(A1,SEARCH(".",A1)+2)),0.05)
That way 85.85015 remailns 85.85 and not 85.90