columns as checkbook

[Brurobiney]

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?

 

[kassie]

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

 

[Brurobiney]

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]

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

 

[Brurobiney]

Thank you!!!!

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

 

[Don Guillett]

You might find that ONE column will do using -100.00 for withdrawals? I also
use a column showing x for cleared, a running total that is graphed to show
cash flow.
Date Payee Memo Debit/Dep B Cat X Balance

 

[David McRitchie]

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