Queue
New member
- Joined
- Mar 1, 2020
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Mac 2016
I am trying to do a calculation with the IF function 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 (eg $450,000) of the property and the above percentage levels. Then the same for choosing "Seller" from the drop down list and do the above criteria.
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 (eg $450,000) of the property and the above percentage levels. Then the same for choosing "Seller" from the drop down list and do the above criteria.