Forum Discussion
Bonus Calculation with multiple targets
Hello, I am trying to determine how I can calculate the amount of a bonus. In my example employees can get different bonus amounts based on how much they sell. There are 3 thresholds and corresp...
Here's another route, just to illustrate the fact that in Excel there are often multiple ways to get from Point A to Point B.
Enter the number of apps in the yellow background cell and the bonus appears in the green.
This is the formula:
=VLOOKUP(B3,BonusTbl,3,1)+(((B3+1)-VLOOKUP(B3,BonusTbl,1,1))*(VLOOKUP(B3,BonusTbl,2,1)))