Thanks Julie

[Sherry]

Julie, thanks for your response, but I'm still lost.
I've done IF statements like that before for simple
addition, but this is a little different. I have a total
stored in a cell C3. I am trying to get it to run a
balance (and not show any value if there are no entries
in the row) of the total less debit plus credit. Then I
want to fill that formula down for 30 rows.

My basic formula would be =(E3-C6)+D6) with E3 containing
the beginning balance, c6 containing a debit (if there
was one) and D6 containing a credit (if there was one).
There will not be a debit and a credit both in one row.
I just want to set up the formula, fill it down, and the
running total not show in the column unless there is an
entry.

Thanks,
Sherry

 

[Bernie Deitrick]

Sherry,

Hard to tell exactly what you want, but if you entered this in E4 and copied
down:

=IF(OR(C4<>"",D4<>""),E3-C4+D4 ,"")

Note that this will fall apart if you skip entire lines when entering values
in C and D...

HTH,
Bernie
MS Excel MVP