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

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

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

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

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