Nesting 'Countif' into 'If' formula

I want to indicate overall status (No,N/A,Yes) based upon data in a number of cells. I have five questions(rows) that have an answer of No, N/A or Yes. Based upon the number of No's, N/As or Yes's. This is the formula I am having trouble with:

In cell $O$8......=IF(COUNTIF($O$10:$O$41,"No")>=1,"No",COUNTIF($O$10:$O$41,"N/A)=5,"N/A","Yes")

I need cell $O$8 to show No, N/A or Yes based upon the criteria.

When I run this I get a #NAME error and it underlines the second "No".

I don't have much hair as it is and am quickly removing what is left on my head!!

Any suggestions?

Try

=IF(COUNTIF($O$10:$O$41,"No")>=1,"No",IF(COUNTIF($O$10:$O$41,"N/A")=5,"N/A","Yes"))

Thank you for the quick replies! I am always amazed at the knowledge gained from these forums! I will try these suggestions and let you know how they work.

I tried the first one and it appears to work! I did notice that my example had a few 'syntax' errors that I should have caught before I submitted the thread. I was using the original example from the MS Help file and could not get it to work with multiple arguments. I would never have thought to add another "IF" classifier within the formula without the help of this forum. Kudo's to all of you for your help!!