How to calculate the Payout from a matrix

[Tishka.Tia]

Hi,

I have a payout matrix of performance versues payout as below.

Performance Payout
0% 200%
83% 200%
100% 100%
117% 75%
>117% 0%

How can I calculate the payout % for a performance within one of the range say 89%.

Please help resolve this.

TIA.
Tishka

[FDibbins]

Hi, welcome to the forum

Perhaps my reply in this thread might be of some assistance?
https://www.excelforum.com/excel-for...ml#post5090178

[humdingaling]

if A1 is 89%
then

Please Login or Register  to view this content.

[Tishka.Tia]

Sorry I think the link is not working

[Tishka.Tia]

Thanks.The formulae is doing a lookup but I was looking at calculating what should be the exact payout for 89% which should be between 200% & 100%

[Tishka.Tia]

Is it possible to use Y=mx+b slope intercept logic to calculate this.

[Saqib Qureshi]

Thanks.The formulae is doing a lookup but I was looking at calculating what should be the exact payout for 89% which should be between 200% & 100%

Change Number Format to %