Incremental Formulae in Excel

L

leonperrins

I'm sure I have done this in the past but can't remember how.
I am setting up a worksheet to record monthly payments.
I want a running total of these payments and a decreasing running total of
the initial lump sum.
ie. C2 = C1 +A2 extended for say 60 months.
E2 = E1 - A2 _______,,_______________

There must be an easier way than entering each new formula.
 
L

leonperrins

This is a sample

Date Payment £ Running Total utstanding

17/05/2006 531 531 63720
531 1062 63189
531 1593 62658
 
Top