Nested IF(ISNUMBER(SEARCH Question

bpajank

New Member
Joined
Oct 23, 2019
Messages
1
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,132
Office Version
365
Platform
Windows
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")))
 

Forum statistics

Threads
1,077,674
Messages
5,335,605
Members
399,028
Latest member
greyland

Some videos you may like

This Week's Hot Topics

Top