Column total issue

[eg6946]

I am using the following formula on my spreadsheet:

A*0.35=B

I have 15 rows using the same formula. When I total the rows in the column using the =SUM(A1:A15), the total is off by one penny. Although, if I post the same numbers without the using the formula, the column totals just fine. What can I do to make the column total correctly using the percentage formula in the rows?

[Carim]

Hi,

Take a look at Jim's explanation ...
http://www.mcgimpsey.com/excel/pennyoff.html