| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND OR problem.
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
Maybe...
=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.4 5-8.45am", "what happens otherwise")) Romileyrunner1 wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
Try the below
=IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"})), IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"") If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
The correct syntax would be:
=IF(AND(H3="Mr D",OR (J3="Mon",J3="Tues",J3="Wed",J3="Thurs",J3="Fri")) ,"12-1pm",IF(AND (H3="Mr O", OR (J3="Mon",J3="Tues",J3="Wed",J3="Thurs",J3="Fri")) ,"7.45-8.45am","")) This will return a blank if those conditions are not met. Hope this helps. Pete On Oct 12, 6:37*pm, Romileyrunner1 wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
'correction
=IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"},0)), IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"})), IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"") If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
Well done you Jacob.
Thanks for your help again. Cheers. RR1 "Jacob Skaria" wrote: Try the below =IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"})), IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"") If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
=IF(AND(H4="Mr
D",ISNUMBER(MATCH(J4,{"Mon","Tues","Wed","Thurs"," Fri"},0))),"12-1pm",IF(AND(H4="Mr O",ISNUMBER(MATCH(J4,{"Mon","Tues","Wed","Thurs"," Fri"}))),"7.45-8.45am","")) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
Thanks for the feedback..Please use the corrected version.
If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: Well done you Jacob. Thanks for your help again. Cheers. RR1 "Jacob Skaria" wrote: Try the below =IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"})), IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"") If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: 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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
Yep, that`s the one Jacob.
Thanks for the corection "Jacob Skaria" wrote: 'correction =IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"},0)), IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below =IF(ISNUMBER(MATCH(J3,{"Mon","Tues","Wed","Thurs", "Fri"})), IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"") If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: 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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
Works great Dave.
Thanks Mate. RR1 "Dave Peterson" wrote: Maybe... =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.4 5-8.45am", "what happens otherwise")) Romileyrunner1 wrote: 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 -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
=IF(LEFT(J3)<"S",IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"")
"Romileyrunner1" wrote: 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 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF AND OR problem.
Yep, that works a treat TM.
Thanks for that. RR1 "Teethless mama" wrote: =IF(LEFT(J3)<"S",IF(H3="Mr D","12-1pm",IF(H3="Mr O","7.45-8.45am","")),"") "Romileyrunner1" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with the 0 value | Excel Discussion (Misc queries) | |||
| IRM problem | Setting up and Configuration of Excel | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with ref | New Users to Excel | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Linear Mode
