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

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

see

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

In article ,
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

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