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

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+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))).
Does any one have any suggestions to what I am doing incorrectly?

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

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


--

"petester" wrote in message
...
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+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))).
Does any one have any suggestions to what I am doing incorrectly?

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

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,"unspecifi ed
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,"unspecifie d
output"))))

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

"petester" wrote in message
...
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+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))).
Does any one have any suggestions to what I am doing incorrectly?

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

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

"David Biddulph" wrote:

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,"unspecifi ed
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,"unspecifie d
output"))))

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

"petester" wrote in message
...
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+J 3)),IF(AND(D3="",E3="yes",K3="L"),G3+H3+J3))).
Does any one have any suggestions to what I am doing incorrectly?