Excel IF Function Problem

[KevinBowers29]

Trying to sort of a formula. I have a cell that my staff select as yes or no. Based on that response, it then looks at another cell and based on the info in that cell it calculates a commission. The problem I am having is that if the answer in the first cell is no, then I want it to return a response of $0. But all I keep getting is "False". Everything else is working well. 

The formula I am using is below, 

=IF(B15="Yes",IF(B3="Retail",SUM(C1,C7:C14)*6%,IF(B3="Contract",SUM(C2,C7:C14)*4.5%,IF(B15="No",0))))

Any assistance would be greatly appreciated. 

Thank you, 

[#2]

@KevinBowers29 

Try

=IF(B15="Yes",IF(B3="Retail",SUM(C1,C7:C14)*6%,IF(B3="Contract",SUM(C2,C7:C14)*4.5%,0)),0)

[#3]

@Hans Vogelaar Thank you, that did not resolve the issue. 

[#4]

@Hans Vogelaar My apologies, it may have worked. Thank you.