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
|