View Single Post
  #1   Report Post  
WTG
 
Posts: n/a
Default Addition problem, number always 2 cents off...Help

I have a little problem with my SUMs

I have 200 to 300 rows of A * B = C

Then I tell it to do a =sum(d1:d300)

All the cells are formated to currency, two decimal places.

when I add up the numbers with an adding machine I'm always 2 - 22
cents off. (2 cents on this sheet, 22 cents on another sheet....)

Can anyone help

Thank you

WTG