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