Nested If Statements or Match/Index???

[djbcktt]

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

[:) Sixthsense :)]

In C15 Cell

=IF(AND(OR(C11={"Yes","No"}),C12="No"), C10*65%,IF(AND(C11="Yes",C12="Yes",C13="x"),(C10*65%)/2,IF(AND(C11="Yes",C12="Yes",C14="x"),0,"")))