Forum Discussion

Mark Angus's avatar
Mark Angus
Copper Contributor
May 27, 2020

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...
Formulas and Functions
karchavez's avatar
karchavez
Brass Contributor
May 27, 2020

Hi Mark Angus ,

Please see attached the solution file and the explanation of the formula, I can assure you it works, since I usually use it in my job.

If this formula  fit your expectations, please accept as best response.

 

Regards,

Karchavez

Mark Angus's avatar
Mark Angus
Copper Contributor
May 27, 2020

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

Resources