Thread: If Formula
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default If Formula

"Str8" wrote in message
...

"bigwheel" wrote:


"Str8" wrote:

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?


This formula would satisfy your conditions:-

=IF(OR(OR(A1="Monday",A1="Wednesday"),OR(B1="Monda y",B1="Wednesday")),"Yes","No")


Thanks for all the replies Ive give them a try.


You don't, presumably, need OR three times; one would do.
=IF(OR(A1="Monday",A1="Wednesday",B1="Monday",B1=" Wednesday"),"Yes","No")
--
David Biddulph