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