Invoice Total depending on deposit and commission

Hi, Hope someone can help.

I have a spreadsheet with Total Sale Price, Deposit Received (Yes/No), Commision Rate and then Invoice Total. For Invoice Total, before I added Commission Rate I had this solved (= IF(Deposit = Yes,Total Sale Price-Deposit, Total Sale Price). Deposit value is constant.

Commision Rate could be : "No", 5% or 10%

Now I have numerous outcomes. The Invoice Total could depend on the deposit being paid (two possibilities) or/and the commission rate (three possibilites). Wow ! Any ideas how I could best calculate the invoice total ?

Check this example and tell me if it helps, and if you can incorporate it:

Spot on. Thanks a million..........

Glad I could help.