View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default formula to see if cell contains one of two text values

Brian

if you wanted to test cell A1, use:

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

Regards

Trevor


"
wrote in message ...
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?