Your schedule is set up incorrectly and you will not have luck with that. I
created this table in A2:B7

10% 125
20% 500
40% 1,500
100% 2,000
200% 5,000
401% 10,000

and used this formula
=INDEX(B2:B7, MATCH(C20, A2:A7,1))

--
HTH...

Jim Thomlinson


"Jim" wrote:

Hello,

In my spreadsheet I have a percent listed in C20 (206%), this is the
salespersons percent to quota. Below I have a chart that breaks down the
salespersons payout based on that percent

Sales Bonus Schedule:
Percent to Quota Bonus
N1 10-19% N2 $125
O1 20-39% O2 $500
P1 40-99% P2 $1,500
Q1 100-199% Q2 $2,000
R1 200-400% R2 $5,000
S1 401% and above S2 $10,000

In D20 I would like to return the amount of the bonus based on the percent
to quota. Something to keep in mind is that the cells that show the percent
to quota range in N1-S1 are in the same cell. This is hte part im having
difficulty with from a formula percepective.

Thanks for the help.
Jim