Row adding incorrectly

[Doris]

I have a payment table where the columns I have are the
Balance less payments plus interest equal new balance. On
row number 28 for some reason the balance plus interest
does not add correctly-it is one cent off. The formulas
are exactly the same-I have copied them for the entire
colums, I have decimals set to 2 spaces. All other rows
are adding correctly and am currently down to row 34. Any
help is appreciated.

 

[Dave R.]

You can look at

http://www.cpearson.com/excel/rounding.htm

You may consider manually rounding some of the products and see if that
helps.

 

[Don Guillett]

You might want to use rounding within your calculations.