What I am trying to do is put a formula in one cell and then copy it to the other cells. The interest is 6.5 and it is compounded monthly (12times per yr) The monthly payment is $1800.
I entered =-PMT($E$5/$E$6,D$9*12,$C11 this made it correct but I also entered in the cell above....=-PMT(E$5/E6,$D$9*E6,$10. Although this last entry gives me the correct answer according to the book (and so does the first entry) I can not seem to use auto fill to complete my grid.
This is so hard for me to grasp and MTS thanks for your explanation, it helps.