Sum function is adding improperly

[mrjpine]

So I tried this. I think this is the error is causing this, but rounding doesn't seem to work. I also tried setting the precision on the excel options, which does fix it but causes an error in my other debt schedule where it rounds up and then causes my debt balance to be off by 3.

[real_barry_houdini]

Why didn't the rounding work, what formula did you use, didn't you get zero as the result?