wild card with if logical function

[b166er]

hi members,

i need help on how to use wild cards(*/?) with if logical
function is it possible to use with if logical function if yes please
just tell me how to use wild cards dont tell me about alternative
functions

 

[Bob Phillips]

Here is one way

=IF(ISNUMBER(FIND("asp",C2)),"found","not found")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)