I need help creating a formula that has been a thorn in my side. I am at a complete loss on what to do. As a note, I don't understand match/index well (really at all). Here is what I am trying to do-

1- C15 will = C10*65% if C11 = No; or if C11 = Yes and C12 = No.
2- C15 will = (C10*65%)/2 if C11 = Yes, C12 = Yes, and C13 = x.
3- C15 will = $0 if C11 = Yes, C12 = Yes, and C14 = x.

How do I make that into one formula? Thanks!Excel Help.xlsx