P
petester
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?
(=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?