Lesliebryce
New Member
- Joined
- Apr 24, 2021
- Messages
- 1
- Office Version
- 2016
- 2010
- Platform
- Windows
Hi,
I need to calculate incentive and it’s based on the minimum, Target, and maximum.
minimum of 50 files gets an incentive of 90%
target of 60 files gets an incentive of 100%
Maximum of 90 files gets an incentive of 150%.
So if someone has 70 files they fall between target and maximum, which would be over the 100% but less than the 150% and the difference of percentage needs be calculated so for example that individual would be at 116% payout. How can I calculate that to incorporate it?
I need to calculate incentive and it’s based on the minimum, Target, and maximum.
minimum of 50 files gets an incentive of 90%
target of 60 files gets an incentive of 100%
Maximum of 90 files gets an incentive of 150%.
So if someone has 70 files they fall between target and maximum, which would be over the 100% but less than the 150% and the difference of percentage needs be calculated so for example that individual would be at 116% payout. How can I calculate that to incorporate it?