if and multiple criteria and if cell doesnt not contain specfic word

Gemma86 · Mar 27th 2017

Please can i have some help to amend the below

works up until the bit highlighted in blue

IF(AND(L2="Enabled")*AND(G2="Yes")*AND(U2="True")*AND(IF,NOT(ISERROR(SEARCH("Guarantee",E2)),"Guarantee Missing","")

Just to note, cell E2 will contain more than just guarantee.

Thank you!

**NBVC** · Mar 27th 2017

Re: if and multiple criteria and if cell doesnt not contain specfic word

Try:

[COLOR="#0000FF"]=IF(AND(L2="Enabled",G2="Yes",U2="True",ISERR(SEARCH("Guarantee",E2))),"Guarantee Missing","")[/COLOR]

or

[COLOR="#0000FF"]=IF(AND(L2="Enabled",G2="Yes",U2="True",ISNUMBER(SEARCH("Guarantee",E2))),"Guarantee Missing","")[/COLOR] if you are looking to find "Guarantee" in E2.

if and multiple criteria and if cell doesnt not contain specfic word

Participate now!

Share