#### vijaymehta

##### New Member

- Joined
- Apr 3, 2010

- Messages
- 10

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.