Previous Topic Next Topic

INCENTIVE SLAB

Closed
DHIRAJ - Feb 11, 2010 at 12:50 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 11, 2010 at 07:15 AM
Hello,

Want to compute the incentive calculation with below slab,

Target Bonus

< 75% 0.00%
75 % To 100% 1.00%
>100 to 125 1.10%
Above 125 % 1.25%

Regards

Dhiraj Verma

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 11, 2010 at 07:15 AM
=(IF(A1<0.75,0,IF(A1<=1,1,IF(A1<=1.25,1.1,1.25))))
1