OR(FIND

[Sasikiran]

Hi,

I am struggling with a formula. This formula basically looks for a specific
text value within a cell and if not found gets displayed as "Yes" else "No"

In the below example, the formula should look for ".abc.com" or ".xyz.com"
in column B and if either of the two criteria is not found should display as
"Yes".

I could able to do with one criteria but could not insert OR function in the
below formula.

=IF(ISERROR(FIND(".abc.com",B2)),"Yes","")


A1 B1 Desired result in column A
= xyz.com Yes
= abc.abc.com No
abv.xyz.com No
abc.abc.com No
xyz.dfg.com Yes
123.dfg.com Yes
fsdfs.wed.com Yes
wer.grt.com Yes


Please help.

 

[Jacob Skaria]

Hi Sasikiran

=IF(COUNT(SEARCH({".abc.com",".xyz.com"},A1)),"No","Yes")