Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbook Register | Excel Discussion (Misc queries) | |||
How do I expand the checkbook register to more than 98 entries? | Excel Worksheet Functions | |||
Check book register template | New Users to Excel | |||
how do i create a running balance on checkbook register | Excel Discussion (Misc queries) | |||
how do i add cells in checkbook register template with formulas? | Excel Worksheet Functions |