If Formula
"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
|