Formula problem

[Guest]

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

 

[Guest]

may be a rounding problem... use:

=ROUND(A10,2)+ROUND(B10,2)

 

[JE McGimpsey]

see

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Gord Dibben]

See John McGimpsey's site for info and instructions.

http://www.mcgimpsey.com/excel/pennyoff.html


Gord Dibben MS Excel MVP