Vary response IF certain text is contained in a cell
In article , Atishoo
writes
=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
"Colin Hayes" wrote:
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
|