sliding scale
In A1 I have a low or base commission target.
In A2 I have a high or stretch commission target.
In A3 I have a revenue number actually experienced that’s between the low and high.
In A4 I have the total dollars available for commission distribution
In A5 I’m looking for a sliding scale formula that will return a portion of available commission dollars in A4 based on the revenue experience in A3, which will be a number between A1 and A2.
Regards, Gary
Okay, so if your actual commission (A3) hits your stretch goal, then you want 100% of the commission money distributed? What if you hit the low commission goal (A1), what % do you want distributed? Let's say that number is "LC"
A5= (1-LC)*A4*A3/A2
Last edited by ChemistB; 11-04-2014 at 09:38 AM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Very good point. The stretch would be 100% of available commission dollars, I'll make the base 25% of available commission dollars.
The formula puts me slightly off with the max distributed 75% instead of the desired 100%.
Could you suggest a small adjustment to the formula?
Thanks for taking time to help, Gary
Oops, oversimplified
Adding B1 = Lowest percentage distributed (i.e. 25%)
B2= Highest (100%)
A5 =FORECAST(A3,B1:B2,A1:A2)*A4
Fantastic. Thanks ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks