QueueRealEstate
New Member
- Joined
- Mar 1, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- MacOS
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 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 of the property and the above percentage levels. Then the same for choosing "Seller" from the drop down list and do the above criteria.
