View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default =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