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

=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

Some formula like:

=if(or(a1="monday", a1="wednesday", b1="monday", b1="wednesday"),"yes",
"no")

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Tool & Training Material for Download
==================================
"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

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

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

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

"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