columns as checkbook
 

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?

columns as checkbook
 

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?

columns as checkbook
 

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?

columns as checkbook
 

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?

columns as checkbook
 

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?

columns as checkbook
 

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

--
Don Guillett
SalesAid Software

"Brurobiney" wrote in message
...
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?

columns as checkbook
 

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?