help required

G

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?
 
M

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
 
Top