Trying to figure out subtle IF command

[Patrick Reany]

I'm trying to figure out a subtle use of the IF command.

I want to setup three columes that keep a running total of debt as
monthly payments are made against it. In column One I have OldTotal.
In column Two I have Payment. In column Three I have NewTotal =
OldTotal - Payment (which I have defined relatively).

This is what I'd like:

OldTotal Payment NewTotal
*************************************
* $3200.00 * $100.00 * $3100.00 *
*************************************
* $3100.00 * $100.00 * $3000.00 *
*************************************
* $3000.00 * * *
*************************************
* * * *
*************************************
etc


This is what I get:

OldTotal Payment NewTotal
*************************************
* $3200.00 * $100.00 * $3100.00 *
*************************************
* $3100.00 * $100.00 * $3000.00 *
*************************************
* $3000.00 * * $3000.00 *
*************************************
* $3000.00 * * $3000.00 *
*************************************
etc

So, I want to use the IF command like this in column One from row Two
on.

IF(in the column one over to the right and row above is blank,do
nothing,NewTotal)

If I can figure out how to do this, I figure out how to do the rest.

Any help appreciated. Thanks.

Patrick

 

[Frank Kabel]

Hi
something like the following in A3:
=IF(B2="","",C2)

and in C2:
=IF(B2="","",A2-B2)