Previous Topic Next Topic

INCENTIVE SLAB

Closed
DHIRAJ - 11 Feb 2010 à 00:50
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Feb 2010 à 07:15
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

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