DmaxHunter
New Member
- Joined
- Feb 16, 2017
- Messages
- 11
Hello,
I'm trying to build a potential bonus structure where we rack and stack (rank) each employee and based off their ranking they get a % of the bonus we have available for distribution for the year. #1 gets the highest % of the bonus and it incrementally decreases from there, all totaling 100%.
I can figure this out manually by simply playing with numbers and coming up with what the decrease is for each decreased rank. In my example I have 18 employees so I found #1 gets 7.8605% then #2 gets .0025 off of it then #3 .0025 off it and so on. But if I add say a 19th employee I have to play around with the numbers to find my starting % for #1 and my decreasing % for each. So, is there a formula I can implement to do this automatically so when I add the 19th employee it re-calculates all on it's own simply based on the value in D2 and I don't have to just sit there and play with the numbers to try and figure it out?
Here are some visuals for what I have so far. Thanks in advance for any help!
I'm trying to build a potential bonus structure where we rack and stack (rank) each employee and based off their ranking they get a % of the bonus we have available for distribution for the year. #1 gets the highest % of the bonus and it incrementally decreases from there, all totaling 100%.
I can figure this out manually by simply playing with numbers and coming up with what the decrease is for each decreased rank. In my example I have 18 employees so I found #1 gets 7.8605% then #2 gets .0025 off of it then #3 .0025 off it and so on. But if I add say a 19th employee I have to play around with the numbers to find my starting % for #1 and my decreasing % for each. So, is there a formula I can implement to do this automatically so when I add the 19th employee it re-calculates all on it's own simply based on the value in D2 and I don't have to just sit there and play with the numbers to try and figure it out?
Here are some visuals for what I have so far. Thanks in advance for any help!