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
|