=OR and =IF Help
 

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

=OR and =IF Help
 

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

HTH

"Pam" wrote:

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

=OR and =IF Help
 

Try this:

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

Mike

"Pam" wrote:

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

=OR and =IF Help
 

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

"Mike H" wrote:

Try this:

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

Mike

"Pam" wrote:

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