If cell contains any of the following letters, then..

[Darin Kramer]

Hi there,

I need an if formulae in a2 that says if cell a1 contains the word
"procedure" then put "x", if not put a "y".

ie an x would be the result if cell a1 stated:
"this is the procedure", or
"procedure is this", or
"this is the only procedure required"

Any ideas...?

Thanks

D


*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

=IF(ISNUMBER(SEARCH("procedure",A1)),"x","y")


--
HTH

Bob Phillips

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

 

[Darin Kramer]

Brilliant!

*** Sent via Developersdex http://www.developersdex.com ***