Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |