I am new to the site and need a little help in my homework assignment. This thing is giving me fits and need to have a payment calculator for a doctors office.
It would be helpful if you could tell us what your problem is. Are you having errors? If yes please copy paste them. Is something not working as intended? Tell us what that is.
Sorry tarik..basically my output is not calculating correctly and trying to figure out whether my calculations are in the wrong place and any suggestions in the loop. I the dates need to add a month to each payment as well. Also i have a pesky blank prompt to enter the $75 to calculate it when it needs to be in the loop as a formula to add to the total paid column.
PAYMENT DUE PAYMENT TOTAL OUTSTANDING
NUMBER DATE AMOUNT PAID BALANCE
75.00 <---some reason it needs to be automatically added to the total pay
and not a prompt
1 2/1/2015 75 2275 2200
2 2/1/2015 75 2200 2125
3 2/1/2015 75 2125 2050
4 2/1/2015 75 2050 1975
5 2/1/2015 75 1975 1900