Checkbook Register template
 

How do I make the two columns I added - another debit and another credit - to
the Checkbook Register Template also calculate against the balance column?

Checkbook Register template
 

how do you intend to use it?Are the columns for two seperate accounts and you
want to see a consolidated balance or do you want another balance column as
well so you can see two a/c at once?
--
paul
remove nospam for email addy!



"PurpleBabs" wrote:

How do I make the two columns I added - another debit and another credit - to
the Checkbook Register Template also calculate against the balance column?

Checkbook Register template
 

"PurpleBabs" wrote in message
...
How do I make the two columns I added - another debit and another credit -
to
the Checkbook Register Template also calculate against the balance column?

If the balance formula originally said:
=IF(AND(ISBLANK(D5),ISBLANK(E5)),"",F4-D5+E5)
and you've now added extra columns such that your debits are columns D and
E and your credits are F and G, and your balance H, then try:
=IF(AND(ISBLANK(D5),ISBLANK(E5),ISBLANK(F5),ISBLAN K(G5)),"",H4-D5-E5+F5+G5)
--
David Biddulph

Checkbook Register template
 

"David Biddulph" wrote in message
...
"PurpleBabs" wrote in message
...
How do I make the two columns I added - another debit and another
credit - to
the Checkbook Register Template also calculate against the balance
column?

If the balance formula originally said:
=IF(AND(ISBLANK(D5),ISBLANK(E5)),"",F4-D5+E5)
and you've now added extra columns such that your debits are columns D and
E and your credits are F and G, and your balance H, then try:
=IF(AND(ISBLANK(D5),ISBLANK(E5),ISBLANK(F5),ISBLAN K(G5)),"",H4-D5-E5+F5+G5)

But it has sensibly been pointed out on another thread that the template
doesn't make sense in the way it deals with blank rows (though it does warn
about this danger). It would therefore make more sense to remove the
"ISBLANK" tests, and hence just be left with =H4-D5-E5+F5+G5.
--
David Biddulph

Checkbook Register template
 

Thanks David, I will try it. I just posted a response to another person
explaining just what you understood from the beginning. As you know, it is
not just simply typing in the formula - I tried - you have to select those
conditions. But this is what I want, the two columns continuously
calculating on the balance. I'll let you know how successful I am later,
it's late now, got to go to bed, work tomorrow.

"David Biddulph" wrote:

"PurpleBabs" wrote in message
...
How do I make the two columns I added - another debit and another credit -
to
the Checkbook Register Template also calculate against the balance column?

If the balance formula originally said:
=IF(AND(ISBLANK(D5),ISBLANK(E5)),"",F4-D5+E5)
and you've now added extra columns such that your debits are columns D and
E and your credits are F and G, and your balance H, then try:
=IF(AND(ISBLANK(D5),ISBLANK(E5),ISBLANK(F5),ISBLAN K(G5)),"",H4-D5-E5+F5+G5)
--
David Biddulph

Checkbook Register template
 

This makes sense to me too. I believe I saw someone saying how this template
does not entirely follow Excel's usual formula setup, hence the 'isblank',
and I think I have tried to just select the columns, but all kinds of logical
issues come up, and that is beyond my understanding; by the end of the day, I
will probably have to just go through my tutorial on Excel rather than go on
what I think I know about Excel. Thanks for helping. I'll keep you posted.

"David Biddulph" wrote:

"David Biddulph" wrote in message
...
"PurpleBabs" wrote in message
...
How do I make the two columns I added - another debit and another
credit - to
the Checkbook Register Template also calculate against the balance
column?

If the balance formula originally said:
=IF(AND(ISBLANK(D5),ISBLANK(E5)),"",F4-D5+E5)
and you've now added extra columns such that your debits are columns D and
E and your credits are F and G, and your balance H, then try:
=IF(AND(ISBLANK(D5),ISBLANK(E5),ISBLANK(F5),ISBLAN K(G5)),"",H4-D5-E5+F5+G5)

But it has sensibly been pointed out on another thread that the template
doesn't make sense in the way it deals with blank rows (though it does warn
about this danger). It would therefore make more sense to remove the
"ISBLANK" tests, and hence just be left with =H4-D5-E5+F5+G5.
--
David Biddulph