IF Function with 2 columns confusion

[adamp1988]

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.

[etaf]

=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

[mehmetcik]

hi

I think that all you need is this.

Please Login or Register  to view this content.

Enjoy

[Pepe Le Mokko]

Why use VALUE(0-D3)? -D3 is more than enough ( I don't quite understand what you are trying to do)

[Pepe Le Mokko]

hi

I think that all you need is this.

Please Login or Register  to view this content.

Enjoy

Again, the use of VALUE is redundant as the arithmetic operators will coerce eventual text strings to numbers

[Harribone]

I think from what you are explaining the formula in Col F should be:

Please Login or Register  to view this content.

As for a running balance the sum of F:F is the current balance assuming the starting value of the account is 0. To make this a running total. you need to enter in G3:

Please Login or Register  to view this content.

Then in G4:

Please Login or Register  to view this content.

This can be copied down to perform a running total.