Tiered Commission Structure Depending on Type of Transaction

I am trying to do a calculation with the that will allow for a commission calculation to take place depending on the transaction type. Here in BC, I am a real estate agent and want to have a calculation based on who is representing whom. For example, the agent representing the buyer will receive the below commission

Commission for the first $100,000 to be paid 3.25% and the balance to paid at 1.15% (Buying Agent)

Commission for the first $100,00 to be paid 3.78% and the balance to be paid at 1.35% (Selling Agent).

If I am representing John Doe and use the drop down list and choose "Buying" then calculate the commission based on the selling price of the property and the above percentage levels. Then the same for choosing "Seller" from the drop down list and do the above criteria.




First 100K Balance
Buying 3.25% 1.15%
Selling 3.75% 1.35%

Name Transaction Type Property Price Commission
John Doe Selling $450000 ?
Jane Doe Buying $650000 ?

that is perfect, thank you. I did not think of using the max/min functions.