I can not seem to get my IF / AND statement to work, help please

[Guest]

This is my IF / AND statement that I can not get to work.
(=IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3))),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))).
Does any one have any suggestions to what I am doing incorrectly?

 

[PCLIVE]

See if this is what you want. Note: Your last IF statement does not appear
to have a FALSE conditions. In other words, what should it do if it is
False?

=IF(AND(D3="yes",E3="",K3="M"),G3-I3-(H3+I3+J3),IF(AND(D3="yes",E3="",K3="L"),G3-I3-J3,IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))))

HTH,
Paul

 

[David Biddulph]

You need to check the matching of the parentheses for each IF statement, and
you need to ensure that each IF has 3 arguments (or not more than 3; you
can get away with 2, but in that case the default would return FALSE for the
unspecified condition).

I've tried to correct your formula without knowing what you're trying to
achieve, but at least to give it valid syntax. I got:
=IF(AND(D3="yes",E3="",K3="M"),(G3-I3-(H3+I3+J3)),IF(AND(D3="yes",E3="",K3="L"),(G3-I3-J3),IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3,"unspecified
output"))))
You could lose a few parentheses to make the counting easier:
=IF(AND(D3="yes",E3="",K3="M"),G3-I3-(H3+I3+J3),IF(AND(D3="yes",E3="",K3="L"),G3-I3-J3,IF(AND(D3="",E3="yes",K3="M"),G3+H3+(H3+I3+J3),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3,"unspecified
output"))))

You might find it clearer if you group situations like
=IF(AND(D3="yes",E3="")... and then separate your K3 conditions after that.

 

[Guest]

Thank you! The rewrite with fewer parentheses did the trick.