Formula problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frances C - 31 Oct 2007 21:23 GMT

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

Reply to this Message

Gary''s Student - 31 Oct 2007 21:46 GMT

may be a rounding problem... use:

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

Signature

Gary''s Student - gsnu200752

> I have a formula that is simply adding two numbers.
>
[quoted text clipped - 7 lines]
>
> thanks

Reply to this Message

JE McGimpsey - 31 Oct 2007 21:46 GMT

see

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

> I have a formula that is simply adding two numbers.
>
[quoted text clipped - 7 lines]
>
> thanks

Reply to this Message

Gord Dibben - 31 Oct 2007 22:25 GMT

See John McGimpsey's site for info and instructions.

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

Gord Dibben MS Excel MVP

>I have a formula that is simply adding two numbers.
>
[quoted text clipped - 7 lines]
>
>thanks

Reply to this Message