help required

[gaffney2006]

Hi,

I am looking for some help. In my excel sheet I have a loan figure. I would
like to reduce this figure every month by the monthly repayment.

Is it possible to have a formula to do this?

 

[Mike H]

Hi,

Put the loan amount in A1 and the monthly repayment in a cell somewhrer. I
used D1.

Put this in A2 and drag down
=A1-$D$1

Mike