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?
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?
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),ISBLANK(G5)),"",H4-D5-E5+F5+G5)
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),ISBLANK(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.
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.
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.
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.
