How do I populate a cell based on 3 possible values in another cell selected from a drop down list?

Below is the formula I've tried for D9 in my workbook and I get the error NAME?

=IF(C9=Yes,"PASS",IF(C开发者_运维知识库9=No,"FAIL",IF(C9=Unclear/Insufficient,"QUERY","-")))

Help appreciated

ALSO....

Having solved that, how do I use the Conditional Formatting icon stack to create a green flag for PASS, orange flag for QUERY and red flag for FAIL?

---

You have to use quotes for YES, NO and the other one:

=IF(C9="Yes","PASS",IF(C9="No","FAIL",IF(C9="Unclear/Insufficient","QUERY","-")))

And using ',' instead of ';' as parameter separator seams strange to me, I supose that is because of your regional configuration or something like that.

---

Try
=IF(C9="Yes","PASS",IF(C9="No","FAIL",IF(C9="Unclear/Insufficient","QUERY","-")))