bigrod
New Member
- Joined
- Nov 17, 2014
- Messages
- 19
Hello all!
I have a workbook with the following columns:
D (Increase), E (Decrease), G(Balance)
There is a dollar figure in G2 already.
What I want is if D and E are empty, I want G to be blank; however, if D has a dollar amount in it (funds added to the account) the amount in D2 to be added to G1 so the new total is reflected in G2. Additionally, if there is a dollar amount in E (reflects a purchase), the amount in E2 should be subtracted from G1 so the new total is shown in G2. I don't want anything showing up in G 4-? until I input another figure in either D or E.
Basically I want the workbook to be clean instead of having $0.00 showing up in the rest of the cells in column G
Sorry for any confusion and thank you very much in advance!
I have a workbook with the following columns:
D (Increase), E (Decrease), G(Balance)
There is a dollar figure in G2 already.
What I want is if D and E are empty, I want G to be blank; however, if D has a dollar amount in it (funds added to the account) the amount in D2 to be added to G1 so the new total is reflected in G2. Additionally, if there is a dollar amount in E (reflects a purchase), the amount in E2 should be subtracted from G1 so the new total is shown in G2. I don't want anything showing up in G 4-? until I input another figure in either D or E.
Basically I want the workbook to be clean instead of having $0.00 showing up in the rest of the cells in column G
Sorry for any confusion and thank you very much in advance!