If Formula

[Guest]

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

 

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Daniel CHEN]

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
==================================

 

[Guest]

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:

 

[Guest]

This formula would satisfy your conditions:-

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

 

[Guest]

Thanks for all the replies Ive give them a try.

This formula would satisfy your conditions:-

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

 

[David Biddulph]

"bigwheel" wrote:

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")