May 24 2018
07:22 AM
- last edited on
Jul 31 2018
08:15 AM
by
TechCommunityAP
May 24 2018
07:22 AM
- last edited on
Jul 31 2018
08:15 AM
by
TechCommunityAP
Hello,
I am trying to create a formulae that allows automatic calculation of an employee's incentive bonus.
An example of what I am trying to create is as follows:
The employee will receive graduated incentive bonus monthly once their generated revenues reaches a threshold of $4000 in a calendar month as follows:
Any suggestions on excel formulae that can be used to determine this calculation utilizing a monthly reference point?
Thank you for your assistance.
May 24 2018 07:34 AM
Dear All,
Could you help me to creat a formulae in Excel sheet as below;
If the the target achieved 100% the customer will get 1%
andIf the the target achieved 120% the customer will get 2%
Thanks