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