K
Kentram
Here is what I am trying to do
Cell Name Account Formula Used
A2 debit Checking
B2 credit Checking
C2 total Checking total
=IF(AND(ISBLANK(A2),ISBLANK(B2)),"",C1-A2+B2)
D2 debit Savings
E2 credit Savings
F2 total Savings Total
=IF(AND(ISBLANK(D2),ISBLANK(E2)),"",F1-D2+E2)
G2 Collected Total
My problem is getting a total for G2. If nothing is in the debit or credit
spaces, excel will not add a number to it (which i like) but i need a formula
that basically says if C2 has a number but F2 does not have a number i want
it to add the total of the two cells anyways and put the total in G2
As it stands now I have to add a "0" to credit or debit just to get a total
of the two cells, and i don't want that because it makes it harder to see
what the total is to the savings account + it keeps adding the new amount
each time it has a total in F2.
If anyone can help me, it would be greatly appreciated.
Thanks in advance
Cell Name Account Formula Used
A2 debit Checking
B2 credit Checking
C2 total Checking total
=IF(AND(ISBLANK(A2),ISBLANK(B2)),"",C1-A2+B2)
D2 debit Savings
E2 credit Savings
F2 total Savings Total
=IF(AND(ISBLANK(D2),ISBLANK(E2)),"",F1-D2+E2)
G2 Collected Total
My problem is getting a total for G2. If nothing is in the debit or credit
spaces, excel will not add a number to it (which i like) but i need a formula
that basically says if C2 has a number but F2 does not have a number i want
it to add the total of the two cells anyways and put the total in G2
As it stands now I have to add a "0" to credit or debit just to get a total
of the two cells, and i don't want that because it makes it harder to see
what the total is to the savings account + it keeps adding the new amount
each time it has a total in F2.
If anyone can help me, it would be greatly appreciated.
Thanks in advance