=OR and =IF Help

[Guest]

I'm trying to do a formula that will look at what someone types in a cell. If
what was typed is one specific word or another, something happens. But if the
person didn't type one of those words, something else will happen.

Any ideas?
tia

 

[Guest]

=IF(OR(A1="word1",A1="word2"),"Do this","do something else")

HTH

 

[Guest]

Try this:

=IF(A1="x","First Option",IF(A1="y","Second Option","Unspecified"))

Mike

 

[Guest]

Thanks so much to both of you. I was on the right track, just needed a bit of
a push!