IF AND OR problem.
Try this:
=IF(AND(H3="Mr
D",OR(J3={"Mon","Tues","Wed","Thurs","Fri"}))," 12-1pm",IF(AND(H3="Mr
O",OR(J3={"Mon", "Tues","Wed","Thurs","Fri"})),"7.45-8.45am",""))
--
Biff
Microsoft Excel MVP
"Romileyrunner1" wrote in message
...
Hi,
I want to do something on the lines of ....
=IF(H3="Mr D", AND IF(J3={"Mon", "Tues", "Wed","Thurs","Fri"},12-1pm),IF
(H3="Mr O, AND IF(J3={"Mon", "Tues", "Wed","Thurs","Fri"}7.45-8.45am)
If that makes any sense to anybody AND IF ANYONE CAN SORT IT OUT, I would
be
very grateful.
Thanks folks.
RR1
|