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

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

--
ve_2nd_at. Randburg, Gauteng, South Africa


"mic" wrote:

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

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


Steve

thank-you... problem has been solved

"stretch" wrote:

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


Steve

thank -you...problem solved

"Kassie" wrote:

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

--
ve_2nd_at. Randburg, Gauteng, South Africa


"mic" wrote:

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

Roger mic, hope I was of some help?
--
ve_2nd_at. Randburg, Gauteng, South Africa


"mic" wrote:

thank -you...problem solved

"Kassie" wrote:

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

--
ve_2nd_at. Randburg, Gauteng, South Africa


"mic" wrote:

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