Forum Discussion
Correct actual new balance after interest minus payment.
I start with an exact dollar and cent balance on a loan calculation. I compute interest to the nearest penny. 21.4 cents is posted as 21 cents. 21.5 would post as 22 cents, etc. When I add interest f...
Round the result of all formulas to 2 decimal places. So for example if your formula for interest is
=interestcalculation
change it to
=ROUND(interestcalculation, 2)
etc.
Thanx for the quick response. Looked through the functions list and didn't see that one. Have a great day.HansVogelaar
interestcalculation was not meant as a real function, just as a placeholder for whatever you're using.
For example if you have
=D2*1.23%
change it to
=ROUND(D2*1.23%, 2)
Yes, I did that when i changed the new balance cells. Thanx for the reminder though. I don't know how I could forget the round function. Just old I guess. The spreadsheet works perfectly now thanx to your quick response. HansVogelaar
