If M is your balance column you do not want to clear it
out because any entry filled in afterwards would have it
Balance (running total) restarted. The formula would still
be the same as if you had values for Debits and Credits.

Suggest you use OFFSET so that you can insert and
delete rows without a lot of difficulty. See
http://www.mvps.org/dmcritchie/excel/offset.htm
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

M5: =OFFSET(M5,-1,0)+K5-I5

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Brurobiney" wrote in message ...
Thank you!!!!

"kassie" wrote:

In M4 =K4-I4
In M5 =IF(AND(I5="",K5=""),"",M4+K5-I5)
Drag the 2nd one down as far as needed

--
Hth

Kassie Kasselman


"Brurobiney" wrote:


Kassie, thank you. I tried to compensate for my mistake but I could not
figure it out. My true set up is my column I is my withdrawls, column K as
my deposits, and column M as my running balance. It all starts on row 4.

Could you please write that formula again.

"kassie" wrote:

Let's say your entries start in row 2.
In M2 enter =K2-C2
In M3 enter =IF(AND(K3="",C3=""),"",M2+K3-C3)

--
Hth

Kassie Kasselman


"Brurobiney" wrote:

I am trying to use a running balance for my worksheet. I have column C as my
withdrawls, column K as my deposits, and column M as my balance. How to I
create a formula for column M to give me a running balance as I add
withdrawls or deposits?