how do i create a running balance on checkbook register

M

mic

I downloaded a checkbook register template and i would like to know how i get
it to automatically add/subtract the debits/credits so i have a current
balance at all times
 
K

Kassie

Hi mic

The logical way would be to add a Balance column. If you have deposits in
say Column C and withdrawals in say Column D, and you start in Row 3 you can
insert an opening balance in E3.

In E4 enter the following formula:

=IF(AND(C4="",D4=""),"",E3+C4-D4)
and copy it doen as far as you wnat to go
 
S

stretch

We would need a bit more information as to what the issues are. Can
you describe the cell structure?


Steve
 
M

mic

thank -you...problem solved

Kassie said:
Hi mic

The logical way would be to add a Balance column. If you have deposits in
say Column C and withdrawals in say Column D, and you start in Row 3 you can
insert an opening balance in E3.

In E4 enter the following formula:

=IF(AND(C4="",D4=""),"",E3+C4-D4)
and copy it doen as far as you wnat to go
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Check register with running balance 0
how do i add a formula to a cell that will add or subrtact from d. 2
how do I create a checkbook register in excell 1
Checkbook Register template 5
Checkbook Register 5
need formula? to include blank cells in "running balance" 5
Checkbook Register 5

Top