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

If I understante what you are lookin for the formula is

=IF(OR(OR((A1="MONDAY"),(A1="WEDNESDAY")),OR((B1=" MONDAY"),(B1="WEDNESDAY"))),"YES"."NO)

Regards from Brazil
Marcelo

"Str8" escreveu:

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