software

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.

Please post some example showing the layout of your data

--
AP

quot;leonperrinsquot; gt; a écrit dans le
message de news: ...
gt; I'm sure I have done this in the past but can't remember how.
gt; I am setting up a worksheet to record monthly payments.
gt; I want a running total of these payments and a decreasing running total of
gt; the initial lump sum.
gt; ie. C2 = C1 A2 extended for say 60 months.
gt; E2 = E1 - A2 _______,,_______________
gt;
gt; There must be an easier way than entering each new formula.

This is a sample

DatePayment £Running Total utstanding

17/05/200653153163720
531106263189
531159362658quot;Ardus Petusquot; wrote:

gt; Please post some example showing the layout of your data
gt;
gt; --
gt; AP
gt;
gt; quot;leonperrinsquot; gt; a écrit dans le
gt; message de news: ...
gt; gt; I'm sure I have done this in the past but can't remember how.
gt; gt; I am setting up a worksheet to record monthly payments.
gt; gt; I want a running total of these payments and a decreasing running total of
gt; gt; the initial lump sum.
gt; gt; ie. C2 = C1 A2 extended for say 60 months.
gt; gt; E2 = E1 - A2 _______,,_______________
gt; gt;
gt; gt; There must be an easier way than entering each new formula.
gt;
gt;
gt;