Drop Down List with If Function

Quentin Lemmer

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.

Paul Newcome

Try something like this...

=IF([Agent Type]@row = "Buying", IF([Selling Price]@row <= 100000, [Selling Price]@row, 100000) * 0.0325 + (([Selling Price]@row - 100000) * 0.0115), IF([Selling Price]@row <= 100000, [Selling Price]@row, 100000) * 0.0378 + (([Selling Price]@row - 100000) * 0.0135))

Quentin Lemmer

Paul, thank you.

Paul Newcome

Happy to help! 👍️