IF Statement equalling multiple words. Please Help

[Phillip Vong]

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

[Cody]

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

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

[Alan]

=IF(OR(A1="word1",A1="Word2",A1="word3"), "do something","do something
else") if any one stement is true or
=IF(AND(A1="word1",A1="Word2",A1="word3"), "do something","do something
else") if all statements are true
Regards,

"Phillip Vong" <phillip_vong*at*yahoo*dot*com> wrote in message
news:%[email protected]...
>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
>

[Phillip Vong]

Thanks guys!

Phil


"Phillip Vong" <phillip_vong*at*yahoo*dot*com> wrote in message
news:%[email protected]...
>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
>

[Ron Rosenfeld]

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