Forum Discussion
Returning a value - Calculating Commissions
Hi need to calculate commissions There is a different commission % depending on the value of the sale Here's what I have done (attached) How do I write a formula that compares the value of the sal...
karchavez Thanks!
Slight problem...
The calculation is not quite right. The commission is a percentage of the Agents Commission but it is triggered by the Rent pa (per annum figure). For Example;
If the rent per annum is $273,300, then the commission should be 5% of the Agents Commision ($46,461), which equals $2,323.
At the moment the formula is calculating the commission as a percentage of the Rent pa (not the agents commission).
Can you provide an adjusted formula to reflect this please?
Really helpful - Thanks
Mark
- Thanks very much 🙂