If Formula

S

Str8

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
 
B

Bob Phillips

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
D

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

Marcelo

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:
 
B

bigwheel

This formula would satisfy your conditions:-

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

Str8

Thanks for all the replies Ive give them a try.

bigwheel said:
This formula would satisfy your conditions:-

=IF(OR(OR(A1="Monday",A1="Wednesday"),OR(B1="Monday",B1="Wednesday")),"Yes","No")
Click to expand...
 
Top