G
Gary
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
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