Thread: Houw to Round
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Michael Bednarek[_8_] Michael Bednarek[_8_] is offline
external usenet poster
 
Posts: 21
Default Houw to Round

On Fri, 1 Apr 2005 22:34:40 -0500, "Thomas Grassi"
wrote in microsoft.public.excel.programming:

How do I round up to 614.12 in the formula?

=SUM(I48/1.075)

My result is 614.11


Correct:
660.17 / 1.075 = 614.111627907 (=614.11)

I48 is 660.17 and is the total including sales tax.


Ahh, 660.17 is wrong because
614.12 * 1.075 = 660.179 (=660.18)

To track down where things go wrong we need more information.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"