Thread: If Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default If Formula

=IF(OR(COUNTIF(A1:B1,{"Monday","Wednesday"})0),"y es","no")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Str8" wrote in message
...
Heres what Im trying to do. Lets say in cell a1 is Monday and in b1 is
Tuesday and in c3 I would like to say if a1 or b1 equals Moday OR

Wednesday
yes if not no?
Any ideas? Thanks