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.

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

so the only way to get to the false here and use E
is if D3 is a negative value or zero

is that the situation you wanted ?

thats how it appears to work in the spreadsheet as well - but 0 or - value and you get a 1

hi

I think that all you need is this.

=VALUE(E3)-VALUE(D3)

Enjoy