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

Thanks for all the replies Ive give them a try.

"bigwheel" wrote:

This formula would satisfy your conditions:-

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

"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?
Any ideas? Thanks