Autosum calc in XL2000 off by $.01 in all columns

[charm73]

I have a spreadsheet of figures that in 2 seperate instances of autosum, the total is $.01 less than the actual total.

One of the columns being calculated uses the formula =SUM(C5:S5)*0.07 to calulate its' values

The other uses =SUM(C5:U5)

Both columns are formatted for accounting with 2 decimal places.

Any ideas? I am stumped[/img]

 

[charm73]

We figured it out, thanks anyways :D

We had to use this formula =ROUND((SUM(C5:S5)*0.07),2) in the cell using =SUM(C5:S5)*0.07 so that it wasn;t calulating in the thousandths