Nesting If and And

[terri]

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

 

[Don Guillett]

Look in the help index for
AND

 

[Per Jessen]

Hi

Look at this:

=IF(AND(N3="Yes",O3="Yes",P3="Yes",Q3="NA"),"Yes","No")

Regards,
Per

 

[Teethless mama]

Try one of these

=IF(AND(COUNTIF(N33,"yes")=3,Q3="NA"),"yes","No")
or
=IF(AND(INDEX(N33="yes",),Q3="NA"),"Yes","No")

 

[terri]

WOW! all three examples work! You are all amazing!!!
thank you sooooo much