Excel formula (2003 Service pak2)

[billdee111]

Good Morning All, I am in need of a formula that would round the answer in Line 7, columns B,C,D & E to always end in 9. Examples: B7 shows 0.66. I need it to show 0.69, C7 shows 2.38. I need to always round up to 2.39. Thanks for any assistance.

[rory]

What do you want 0.00 to be? 0.00 or 0.09?

[billdee111]

Hi Rory, thanks for the response. 0.00 would be 0.00

[rory]

Try the attached and see if it works for you.

[billdee111]

Hi Rory
Works perfectly. I attempted to use roundup, with no sucess. I do not understand how your formula works, but thanks it works great!

[rory]

Because you are using 2 decimal places, if you round up to 1 decimal place and then subtract 0.01 you will always get 9 at the end. The other bit of the formula makes sure this only happens if the total is not 0.
HTH

[billdee111]

Thanks again Rory for your help and the explanation. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

[rory]

Glad to oblige!