| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting If and And
I'm trying to nest this:
IF(and(N3="Yes",and(O3="Yes",and(P3="Yes",and(Q3=" NA","Yes","No") but it doesn't work :( help please -- terri |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting If and And
Look in the help index for
AND -- Don Guillett Microsoft MVP Excel SalesAid Software "terri" wrote in message ... I'm trying to nest this: IF(and(N3="Yes",and(O3="Yes",and(P3="Yes",and(Q3=" NA","Yes","No") but it doesn't work :( help please -- terri |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting If and And
Hi
Look at this: =IF(AND(N3="Yes",O3="Yes",P3="Yes",Q3="NA"),"Yes", "No") Regards, Per "terri" skrev i meddelelsen ... I'm trying to nest this: IF(and(N3="Yes",and(O3="Yes",and(P3="Yes",and(Q3=" NA","Yes","No") but it doesn't work :( help please -- terri |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting If and And
Try one of these
=IF(AND(COUNTIF(N3:P3,"yes")=3,Q3="NA"),"yes","No" ) or =IF(AND(INDEX(N3:P3="yes",),Q3="NA"),"Yes","No") "terri" wrote: I'm trying to nest this: IF(and(N3="Yes",and(O3="Yes",and(P3="Yes",and(Q3=" NA","Yes","No") but it doesn't work :( help please -- terri |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting If and And
WOW! all three examples work! You are all amazing!!!
thank you sooooo much :) :) -- terri "Teethless mama" wrote: Try one of these =IF(AND(COUNTIF(N3:P3,"yes")=3,Q3="NA"),"yes","No" ) or =IF(AND(INDEX(N3:P3="yes",),Q3="NA"),"Yes","No") "terri" wrote: I'm trying to nest this: IF(and(N3="Yes",and(O3="Yes",and(P3="Yes",and(Q3=" NA","Yes","No") but it doesn't work :( help please -- terri |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting if/or/and | Excel Worksheet Functions | |||
| Nesting | Excel Worksheet Functions | |||
| Nesting | Excel Worksheet Functions | |||
| OR Nesting? | Excel Discussion (Misc queries) | |||
| IF - Nesting... almost got it - need a bit of help | Excel Worksheet Functions | |||
Hybrid Mode
