|
Posted to microsoft.public.excel.programming
|
|
|
Sales Commission
Take a look he
http://www.mcgimpsey.com/excel/variablerate.html
In article ,
Tim Mears
wrote:
Many Thanks for your response
I have the formula
=IF(N44000,"0.12",IF(N4500,"0.1",IF(N4<500,"0.06 ","0.06")))
To calculate the sales percentage to pay, this give me the correct
figure however if the next month i put in a figure which takes it over
a threshold it calcualtes the new rate ie 10% however calculates 10% of
the whole monthly figure and not just the amount over that threshold!!
for example
Month 1 - £300 therfere 6% of £300 = £18
Month 2 - a further £300
This takes it over the threshold of 500 therefore 10% however i only
want to pay the 10% on £100 (£600 - threshold £500 = £100) and 6% on
the £200 therefore total commission of £22
Many Thanks i am lost here a bit out of my depth
Tim
|