New Forum | Previous | Next | (P-PDF) Beginners

Topic: Rounding up problem
Conf: (P-PDF) Beginners, Msg: 81934
From: kelloggfan
Date: 2/22/2003 01:07 AM

I have a product total field "c" ( a*b=c). "a" has no decimal places, "b" has 4 decimal places and "c" has 2 decimal places.
There are 7 c's as follows:

a1*b1=c1
a2*b2=c2
a3*b3=c3 and so on...

Then I add c1+c2+c3...=Ctotal(2 decimal places)

I am having a problem with rounding the "Ctotal" answer. For example the answer should be $1243.27 but it is $1243.26. It is not rounding up "ctotal" HOWEVER it IS rounding up c1,c2,c3,c4,c5,c6 and c7. So why is it not getting the correct answer when adding all the "c's"? It looks like it is adding the 4 decimal places without rounding. How do I get around this?