Formula problem
may be a rounding problem... use:
=ROUND(A10,2)+ROUND(B10,2)
--
Gary''s Student - gsnu200752
"Frances C" wrote:
I have a formula that is simply adding two numbers.
A10 is the total addition of A1:A9 A10= 47,307.55
B10 is the total addition of B1:B9 B10= 139.09
Then when I add A10 + B10 = C10 (C10=47441.63) is off by a penny)
Can you provide me with a formula that can correct this problem?
thanks
|