Multiple IF Formula Based on Content of Multiple Cells

[bigrod]

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!

 

[jasonb75]

Try

=IF(SUM(D2:E2),G1+D2-E2,"")

 

[bigrod]

Try

=IF(SUM(D2:E2),G1+D2-E2,"")

Jason,

Thank you, it worked, disregard my two other stupid posts if you saw them. I forgot to pull the formula down the remaining G cells.