Don't think I was clear on my last question. Here is the table:
Bonus
0%-22.5% 7200
22.6%-23.8% 6600
23.9%-25% 6000
25.1%-26.3% 4800
26.4%-27.5% 3600
As you can see it is a range, not just one number. If our % is 26.9 what
function do I use to calculate the bonus payoff? I know the answer is 3600,
but how do I get excel to calculate it?