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"