I need this for the incentive sheet.

here are the columns. I need the formula in the %age column.

Names Sales(20%weightage) %age




As we enter sales in the sales column, I want the %age column to calculate
the incentive based on these conditions.

Suppose we have data in 20 rows. Names and sales. Top 2 (10% of 20) will get
full 20% incentive, Next 6 (30% of 20) will get (.6*.2), Next 10 (50% of 20)
will get (.3*.2) and bottom 2 (10% of 20) will get 0.

20 is just an example. It could be any number. If its 18, the top 10% would
still be 2. If its 14, the top 10% should be 1.

Let me know if I need to explain more.

Thanks