I have 5 ranges of percentages
Below 100%
105-110
115-120
So on and so forth
Each of these scores are to return a bonus payout for an employee. For instance - Below 100 is 0, 105-110 is 5 etc.
Is there a formula that can take a percentage range from the top and tell the employee their bonus payout?
You could probably do this with a vlookup() or INDEX/MATCH function, but you would need to use the lower value of the range for each level. something like this...
D2=IF(C2<1,0,VLOOKUP(C2,$A$2:$B$5,2,1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks as always - my only problem is that their payouts are within a range. So if they score a 103, They fall in the 2% range
0-99% - No payout
100-105% - 2%
106%-110% - 3% payout
My table was an example of how this would work, all you need to do is adjust my % to match what you need
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks