Calculation formula for incentive

[Excel Dumbo]

Hello Excel friends,

Please help me with a formula to calculate incentives as shown in the attached spreadsheet.

For example- IF % of Target achieved is 95.63%, incentive will be 60% of Sales ($1667) , answer will be $1000

[ncmay]

Could you explain cell A11 "Additional % up to" & B11 "+1%"

[JBeaucaire]

http://screencast.com/t/JLZOj9awUIq

As shown in the pic above, fix your incentive table so that it lists all the percentage tier START points (the end is implied when the next tier starts), then the formula in I17 would be:

=I15 * VLOOKUP(I14, $A$3:$B$11, 2, 1)

I think you'll need to add a 0% = 0% at the beginning of your table to be complete.

Also, the percentages above 106%... not sure what's going on there.