As Max has pointed out elsewhere, FIND is a case **sensitive** function
whereas SEARCH is not. What I was trying to say, before I screwed my
response up royally, is that you can use FIND for this case because you are
looking for a value (300) which does not have upper/lower case issues.

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
You can use Find for case insensitive searches like this....

=IF(ISNUMBER(FIND(300,A2)),"Yes","No")

If you need case sensitivity, then you would use the SEARCH function
instead.

Rick


"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