formula to see if cell contains one of two text values

  • Thread starter Thread starter brian.h.coleman
  • Start date Start date
B

brian.h.coleman

I am interested in writing a formula that will check to
see if a cell contains one of two words, and then will
return a value.

So, for example:

=IF(ISNUMBER("textA" or "textB"),"yes","no")

I know this formula isnt exactly correct. Can you help?
 
Hi
one way:
=IF(OR(COUNTIF(A1,{"*textA*","*textB*"})),"yes","no")

--
Regards
Frank Kabel
Frankfurt, Germany

"(e-mail address removed)"
 
Brian

if you wanted to test cell A1, use:

=IF(OR(A1="textA", A1="textB"),"yes","no")

Regards

Trevor
 
Back
Top