Formulating commissions in excel

I am trying to set up a spreed sheet to help a company keep track of commissions that have a maximum payment on percentage to the company. The sales rep is on a 60/40 split until a "cap" is reached for the year. After the cap is reached the sales rep is on 100% commission until the beginning of the next year. There are two separate "caps" the company collects. One is a 40% spit of the deal until the company receives 23k. The other is a 3% split until the royalties division receives 3k

I want to formulas to add up the appropriate commission from both sheets and if the amounts are <= the cap I want them to continue to display the returned value up to the maximum cap value. If the numbers go above the "cap" I want the formula to continue to accumulate a value until the cap is reached and then stop counting the values and show a value of "$0.00"

In the picture you can see the formula for each column displayed in row 5. The two columns I am working on trying to under stand are F and G which reach their max commission to the company at 23k and 3k respectively.


Commision Sheet.png

Attached is the spreadsheet for the question posed to the thread.