IF Statement Help

[slinky192001]

Hello,

I have the following statement.

I to amend the last part after "DCS" to say if Q2 is "HHU" and AI is "1", then show DS. If Q2 is HHU and AI is "0" then "HHU".

=IF(ISNUMBER(SEARCH("*A3P - SV*",Q2)),"SV",IF(ISNUMBER(SEARCH("*A3P - SP*",Q2)),"SP",IF(ISNUMBER(SEARCH("*A3P - DCS*",AF2)),"DCS",IF(ISNUMBER(SEARCH("*HHU*",Q2))," HHU",I2))))

I am really stuck, not matter where i add the AND it will not work.

Thank You
Clare

 

[CharlesChuckieCharles]

Not sure why you don't get errors

try

=IF(NOT(ISERR(SEARCH("*A3P - SV*",Q2))),"SV",IF(NOT(ISERR(SEARCH("*A3P - SP*",Q2))),"SP",IF(NOT(ISERR(SEARCH("*A3P - DCS*",AF2))),"DCS",IF(AND(NOT(ISERR(SEARCH("*HHU*",Q2))),AA2="1"),"DS",IF(AND(NOT(ISERR(SEARCH("*HHU*",Q2))),AA2="0"),"HHU",I2)))))


Might be better to re-structure to remove NOT's

=IF(ISERR(SEARCH("*A3P - SV*",Q2)),IF(ISERR(SEARCH("*A3P - SP*",Q2)),IF(ISERR(SEARCH("*A3P - DCS*",AF2)),IF(AND(ISERR(SEARCH("*HHU*",Q2)),AA2="1"),IF(AND(ISERR(SEARCH("*HHU*",Q2)),AA2="0"),I2,"HHU"),"DS"),"DCS"),"SP"),"SV")