On Thu, 17 Mar 2005 13:52:40 -0500, "Phillip Vong"
<phillip_vong*at*yahoo*dot*com 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
A little shorter:
=IF(OR(A1={"word1","word2","word3"}),"","do this")
--ron
|