Simple calculation help...

[bsd13]

I'm sure this is really simple, but I'm at a loss.

I'm making a debt payoff sheet. In column 1 I have the total of each debt, in column two I have the amount paid towards column 1, and in 3 I have column 1 - column 2. Fairly simple. Problem is that I would like column 2 to keep track of how much total has been paid.

For example say the figure in column 1 is $15,000.00 and pay $5,000.00 and put it into column 2, column 3 reflects the new balance ($10,000.00) but if a month later I make another payment and say put $2,000.00 into column 2 instead of column 3 saying $8,000.00 it says $12,000.00 because it (column 2) doesn't save the previous input payment.

Does that even make sense to anyone and if it does how can I go about fixing this?

Thanks!

[squenson]

bsd13,

I understand what you want but I consider it very risky. Suppose that instead of typing $3,000 in column 2, you type $300 then press Enter. You will have difficulty to reverse the calculation. And if you have several updates to be done and are interrupted during your task, how will you be *sure* that you have entered the values for each row?

What I suggest is that you create a new row for each payment, then you can use the SUM or SUMIF functions to calculate the sum of payments from an individual. It will also allow you to make further analysis (like how much was paid within a month).

If you really, really need such feature, a macro can do it. Let us know.
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<

[bsd13]

Thanks for the reply. I'll try it the way you suggest and see how it goes. Unless someone else has a better idea?