Something for you to experiment with:
=IF(ISNUMBER(FIND("300",A1)),"X","Y")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Chacky" wrote in message
...
Is it possible to use wildcards in an IF function to test a text string in
a
cell.

I have a cell that could contain 2 text string options
"300 Denier Polyester" or
"600 Denier Polyester"

Because the operators who input this text may write it in different ways
(300 Denier Polyester or Polyester 300 Denier)
I would like to write an IF function in another cell that tests the cell
in
question for whether the string contains 300 or 600 and depending on the
result, perform a different calculation