Need help with IF(AND function. Please help!!!
 

Hello,

Trying to make the following formulas work, but have extreme trouble with
it. Any help would be great. Thanks in advance.

=IF(AND(K2="POS",M2="TONE",L2="AMB"),"NO
ACTION"),IF(AND(K2="NEG",M2="TONE",L2="AMB"),"SCR" ),IF(AND(K2="POS",N2="ACCURATE",M2="TOPIC"),"
NO ACTION "),IF(AND(K2="POS",N2="INACCURATE",M2="TOPIC"),"ME DIA
OPS"),IF(AND(K2="NEG",N2="ACCURATE",M2="TOPIC"),"S TRATCOM, SPOKESMAN, MEDIA
OPS"),IF(AND(K2="NEG",N2="INACCURATE",M2="TOPIC"), "SPOKESMAN, MEDIA
OPS"),IF(AND(N2="DISPUTED",M2="TOPIC"),"RESEARCH FURTHER")

Need help with IF(AND function. Please help!!!
 

You can't embed more than 7 IFs, have to find another way! Specify your
question in plain words, attach data layout, maybe we can help you to find
one.
Stefi


€žISAF Media Analysis€� ezt Ã*rta:

Hello,

Trying to make the following formulas work, but have extreme trouble with
it. Any help would be great. Thanks in advance.

=IF(AND(K2="POS",M2="TONE",L2="AMB"),"NO
ACTION"),IF(AND(K2="NEG",M2="TONE",L2="AMB"),"SCR" ),IF(AND(K2="POS",N2="ACCURATE",M2="TOPIC"),"
NO ACTION "),IF(AND(K2="POS",N2="INACCURATE",M2="TOPIC"),"ME DIA
OPS"),IF(AND(K2="NEG",N2="ACCURATE",M2="TOPIC"),"S TRATCOM, SPOKESMAN, MEDIA
OPS"),IF(AND(K2="NEG",N2="INACCURATE",M2="TOPIC"), "SPOKESMAN, MEDIA
OPS"),IF(AND(N2="DISPUTED",M2="TOPIC"),"RESEARCH FURTHER")

Need help with IF(AND function. Please help!!!
 

Try the below

(all in one line)
=IF(AND(K2="POS",M2="TONE",L2="AMB"),"NO
ACTION",IF(AND(K2="NEG",M2="TONE",L2="AMB"),"SCR", IF(AND(K2="POS",N2="ACCURATE",M2="TOPIC"),"NO
ACTION ",IF(AND(K2="POS",N2="INACCURATE",M2="TOPIC"),"MED IA
OPS",IF(AND(K2="NEG",N2="ACCURATE",M2="TOPIC"),"ST RATCOM, SPOKESMAN, MEDIA
OPS",IF(AND(K2="NEG",N2="INACCURATE",M2="TOPIC")," SPOKESMAN, MEDIA
OPS",IF(AND(N2="DISPUTED",M2="TOPIC"),"RESEARCH FURTHER","")))))))

If this post helps click Yes
---------------
Jacob Skaria


"ISAF Media Analysis" wrote:

Hello,

Trying to make the following formulas work, but have extreme trouble with
it. Any help would be great. Thanks in advance.

=IF(AND(K2="POS",M2="TONE",L2="AMB"),"NO
ACTION"),IF(AND(K2="NEG",M2="TONE",L2="AMB"),"SCR" ),IF(AND(K2="POS",N2="ACCURATE",M2="TOPIC"),"
NO ACTION "),IF(AND(K2="POS",N2="INACCURATE",M2="TOPIC"),"ME DIA
OPS"),IF(AND(K2="NEG",N2="ACCURATE",M2="TOPIC"),"S TRATCOM, SPOKESMAN, MEDIA
OPS"),IF(AND(K2="NEG",N2="INACCURATE",M2="TOPIC"), "SPOKESMAN, MEDIA
OPS"),IF(AND(N2="DISPUTED",M2="TOPIC"),"RESEARCH FURTHER")