Nesting If and And

T

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
 
P

Per Jessen

Hi

Look at this:

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

Regards,
Per
 
T

Teethless mama

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")
 
Top