See John McGimpsey's site for info and instructions.
http://www.mcgimpsey.com/excel/pennyoff.html
Gord Dibben MS Excel MVP
On Wed, 31 Oct 2007 13:23:01 -0700, 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