View Single Post
  #2   Report Post  
Cody
 
Posts: n/a
Default


Use and If(or(A1="word1",A1="word2",A1="word3"),then"",els e)

That should work for you,
Cody

"Phillip Vong" wrote:

I want to say if cell A1 = "word1" or "word2" or "word3", then "".
Otherwise do this.

I know how to make check if it = 1 item, but how do you make it check 3 or
four things without using multiple IF statements?

Thanks

Phil