View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default If cell contains any of the following letters, then..


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 ***