Unequal Sliding Scale Formula

[Aclowntant]

Can anyone help me with an unequal sliding scale formula?

In previous years the calculation has worked fine on;

Threshold payout 33% when 95% of target is achieved
On target payout 67% when 100% of target is achieved
Exceeded payout 100% when 105% of target is achieved

However this year it needs to be;

Threshold payout 33% when 95% of target is achieved
On Target payout 67% when 100% of target is achieved
Exceeded payout 133% when 110% of target is achieved

Anything less than 95% of target pays nothing and 133% payout is the absolute maximum.

I have attached some examples, any suggestions greatly appreciated - Thank you!

Book1.xls

[shg]

In H5 and copy down,

=IF(G5<95%, 0, IF(G5>110%, 133%, PERCENTILE({33,67,133}%, PERCENTRANK({95,100,110}%, G5))))