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

  • Thread starter ISAF Media Analysis
  • Start date
I

ISAF Media Analysis

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"),"MEDIA
OPS"),IF(AND(K2="NEG",N2="ACCURATE",M2="TOPIC"),"STRATCOM, SPOKESMAN, MEDIA
OPS"),IF(AND(K2="NEG",N2="INACCURATE",M2="TOPIC"),"SPOKESMAN, MEDIA
OPS"),IF(AND(N2="DISPUTED",M2="TOPIC"),"RESEARCH FURTHER")
 
S

Stefi

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:
 
J

Jacob Skaria

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"),"MEDIA
OPS",IF(AND(K2="NEG",N2="ACCURATE",M2="TOPIC"),"STRATCOM, 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula is true if proportion of range is true 3
Easiest way to find differences between Rows? 3
Good code, need one more step 3
Need help with an IF Function 4
Problems with using match and index functions 0
XL2000: Networkdays function giving wrong answers 1
Depreciation Spreadsheet 3
Help with worksheet formulas....Please? 3

Top