vijaymehta
New Member
- Joined
- Apr 3, 2010
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hi all, I am facing some issue while setting up formula for target based incentive. Problem set has 3 classes:
Below 80% achievement - payout is 0%
at 92.5% achievement - payout is 100%
Between 80% to 92.5% - payout is proportion (basically the gap between 80% and 92.5% represents 100%)
At 100%, payout is 107.5%
between 92.5% and 100% - payout is proportion (represents 7.5% basically)
I am struggling to get the proportion right by providing input cell to set this class limits. Tried using with vlookup (with false argument) but it misses on proportion calculation. Using If formula, I am messing it up on proportion output.
No VBA, it needs to be formula driven with provision to provide input criteria.
Any help will be much appreciated.
Below 80% achievement - payout is 0%
at 92.5% achievement - payout is 100%
Between 80% to 92.5% - payout is proportion (basically the gap between 80% and 92.5% represents 100%)
At 100%, payout is 107.5%
between 92.5% and 100% - payout is proportion (represents 7.5% basically)
I am struggling to get the proportion right by providing input cell to set this class limits. Tried using with vlookup (with false argument) but it misses on proportion calculation. Using If formula, I am messing it up on proportion output.
No VBA, it needs to be formula driven with provision to provide input criteria.
Any help will be much appreciated.