darrenciccone
Board Regular
- Joined
- Sep 27, 2007
- Messages
- 72
Hello, I will say thank you in advance for all your help.
I am working with a bonus project and I have corresponding % rates (for a certain percentage increase of unit sales; so for example if customer A bought 100 widgets last year and then this year he buys 105 he falls into the 101%-105% increase in units bought category that extra 5 units qualifies for a $ bonus based upon dollar sales of the incremntal units and I want the formula to return the appropiate % on the incremental dollar amount; so that for a range 1%-5% it Mulitplies the Incremental dollar amount by 1% and moreover if it were to change that unit volumes increased by 10% it would give back 2% on the incremental dollar purchases, and if it was 111%-115% it would be 3%.. etc.....
right now I have each % in columns and i have to manually check the % increases and it takes way too long
so right now there are 4 diffrent scales 101%-105% 106%-110%
111%-115% and 115% + so I need 4 arguments and I dont know where to begin
If anyone has some insight it would be greatly appreciated and if u need more info just ask!!
Thanks again
I am working with a bonus project and I have corresponding % rates (for a certain percentage increase of unit sales; so for example if customer A bought 100 widgets last year and then this year he buys 105 he falls into the 101%-105% increase in units bought category that extra 5 units qualifies for a $ bonus based upon dollar sales of the incremntal units and I want the formula to return the appropiate % on the incremental dollar amount; so that for a range 1%-5% it Mulitplies the Incremental dollar amount by 1% and moreover if it were to change that unit volumes increased by 10% it would give back 2% on the incremental dollar purchases, and if it was 111%-115% it would be 3%.. etc.....
right now I have each % in columns and i have to manually check the % increases and it takes way too long

so right now there are 4 diffrent scales 101%-105% 106%-110%
111%-115% and 115% + so I need 4 arguments and I dont know where to begin

Thanks again