Thread: Formula problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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