Excel 2007 : IF Statement Help

[jesz1987]

Hello,

I have 11 questions on an excel sheet - The answer to them is either YES OR NO OR N/A.

I want a cell that says

if they are all YES THEN ITS A PASS
if ONE of them IS NO, THEN ITS A FAIL
if any are N/A then ignore

Please help
Thank you

[TMS]

I don't understand

if any are N/A then ignore

Do you want all 11 questions to be "yes" for a pass? If so, N/A are irrelevant.

=IF(COUNTIF(A1:A11,"yes")=11,"Pass","Fail")

or

=IF((COUNTIF(A1:A11,"yes")+COUNTIF(A1:A11,"N/A"))=11,"Pass","Fail")

or

=IF(COUNTIF(A1:A11,"no")>1,"Fail","Pass")

Depending on your preference.


Regards

[jesz1987]

Thanks very much mate bottom one works great, had to add = to or less than 1 NO works perfect

[TMS]

You're welcome. Sorry, missed the "equals one".

If this has answered your question, please mark your thread as solved. See my signature for details or the FAQ.

Regards