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