columns as checkbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brurobiney - 22 Dec 2006 04:56 GMT

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?

Reply to this Message

kassie - 22 Dec 2006 05:08 GMT

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

Signature

Hth

Kassie Kasselman

> 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?

Reply to this Message

Brurobiney - 22 Dec 2006 05:55 GMT

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.

> Let's say your entries start in row 2.
> In M2 enter =K2-C2
[quoted text clipped - 4 lines]
> > create a formula for column M to give me a running balance as I add
> > withdrawls or deposits?

Reply to this Message

kassie - 22 Dec 2006 06:09 GMT

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

Signature

Hth

Kassie Kasselman

> 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
[quoted text clipped - 10 lines]
> > > create a formula for column M to give me a running balance as I add
> > > withdrawls or deposits?

Reply to this Message

Brurobiney - 22 Dec 2006 06:12 GMT

Thank you!!!!

> In M4 =K4-I4
> In M5 =IF(AND(I5="",K5=""),"",M4+K5-I5)
[quoted text clipped - 14 lines]
> > > > create a formula for column M to give me a running balance as I add
> > > > withdrawls or deposits?

Reply to this Message

David McRitchie - 28 Dec 2006 22:17 GMT

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

> Thank you!!!!
>
[quoted text clipped - 16 lines]
> > > > > create a formula for column M to give me a running balance as I add
> > > > > withdrawls or deposits?

Reply to this Message

Don Guillett - 22 Dec 2006 14:05 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>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?

Reply to this Message