Vary response IF certain text is contained in a cell

[Colin Hayes]

Hi All

I need a formula which says this :

If the text 'AB' is contained anywhere in E2 , put 'Yes'. If not put
'No'.

Can someone help with this?



Best Wishes

 

[Atishoo]

=IF(ISERROR(FIND("ab",E2,1)),"No","Yes")

 

[Colin Hayes]

=IF(ISERROR(FIND("ab",E2,1)),"No","Yes")

Hi

OK Thanks for getting back.

I'm trying to incorporate the first part of the code above into my
existing formula :

=IF(D2<=20,J2,IF(J2=2,6,IF(OR(J2=1,J2=11),5,J2)))


Instead of saying 'if D2 is greater or equal to 20' , I need to say 'If
E2 contains AB'.


The 'Yes' and 'No' replies from above would not be needed therefore.

I keep getting errors. Can you advise?


Thanks again.

Best Wishes

 

[Ashish Mathur]

Hi

=IF(isnumber(search("ab",E2,1)),J2,IF(J2=2,6,IF(OR(J2=1,J2=11),5,J2)))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com