# Thread: Excel formula (2003 Service pak2)

1. ## Excel formula (2003 Service pak2)

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.

2. ## Re: Excel formula (2003 Service pak2)

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

3. ## Re: Excel formula (2003 Service pak2)

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

4. ## Re: Excel formula (2003 Service pak2)

Try the attached and see if it works for you.

5. ## Re: Excel formula (2003 Service pak2)

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!

6. ## Re: Excel formula (2003 Service pak2)

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

7. ## Re: Excel formula (2003 Service pak2)

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

8. ## Re: Excel formula (2003 Service pak2)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•