Nested IF(ISNUMBER(SEARCH Question

[bpajank]

Hello!

I am trying to get the following to work, but I think I am missing a ( somewhere along the lines:

New Formula

=IF(ISNUMBER(SEARCH("Attn Needed",E2)),"Collection Needed",IF(AND(ISNUMBER(SEARCH("B2B_Certified",M2),ISNUMBER(SEARCH("DOTCOM_Certified,M2),"Complete")),IF(ISNUMBER(SEARCH("Disco",J2)),"Discontinued-Stop Collection","Collection Needed")))


My old formula worked perfectly, but I added the IF(AND function the above..I need a cell to contain both B2B_Certified AND DOTCOM_Certified to be considered COMPLETE.

Old formula:

=IF(ISNUMBER(SEARCH("Attn Needed",E2)),"Collection Needed",IF(ISNUMBER(SEARCH("B2B_Certified",M2)),"Complete",IF(ISNUMBER(SEARCH("Disco",J2)),"Discontinued-Stop Collection","Collection Needed")))

 

[Fluff]

Re: Nested IF(ISNUMBER(SEARCH Question-HELP!

Hi & welcome to MrExcel.
You have brackets in the wrong place & are missing a closing ", try
=IF(ISNUMBER(SEARCH("Attn Needed",E2)),"Collection Needed",IF(AND(ISNUMBER(SEARCH("B2B_Certified",M2)),ISNUMBER(SEARCH("DOTCOM_Certified",M2))),"Complete",IF(ISNUMBER(SEARCH("Disco",J2)),"Discontinued-Stop Collection","Collection Needed")))