Assuming the balance column is column L.

The current balance is the previous balance minus any current debits plus
any current deposits.

So, if you have this data...

-----A-------B--------C---
1--Debits...Deposit...Balance
2--------------------5000
3--100------500----

The current balance formula in C3 would be:

=IF(COUNT(A3:B3),C2-A3+B3,"")

--
Biff
Microsoft Excel MVP


"Norma" wrote in message
...
I am doing a finance spreadsheet. It's set up like a checkbook transaction
register. To the far right, I have the balance box. I have a deduction
cell
(I) and a deposit cell (K). I have it to where there is a transaction and
I
enter the amount on cell (I), it automatically deducts that amount from
the
current balance. I want to know if I can have a formula that will add the
deposit I enter on (K) and add it to current balance.