Welshsparkles3, Good afternoon.

Try to use:

F12 --> =IF(OR(F9="yes",F11="yes"),"YES","NO")

Is this what you want?
I hope it helps.