IF Function with 2 columns confusion

Hello all,

I'm having slight difficulty with a multiple IF function. I have the following fomula:

=IF(D3="",0,IF(D3>0,VALUE(0-D3),IF(E3="",0,IF(E3>0,1,0))))

The D3 column works, but the E3 column does not. I am trying to construct a simple Accounts T-Chart (which I Have attached for reference).

The D-column is debit, E-column is credit; the F column will be either the inverse (by value(0-D3)) of the value in D3, or the value of E3, and the running balance in Column G will be the sum of F:F. The F-column will contain the function and be hidden once completed.

Anyone have any insight? I tried researching the AND function and although I understand the basics, it does not produce the data needed.