Performance and Payment formula with two Slopes

[qballer48]

Looking for a formula to help calculate a payout given a level of performance with two different slopes. I tried a combination of if(and) with a forecast.linear but keep getting an error some help would be greatly appreciated! Here's what the table looks like.

Performance	Payout
90%	50%
92%	60%
94%	70%
96%	80%
98%	90%
100%	100%
101%	110%
103%	130%
105%	150%

 

[Eric W]

Welcome to the MrExcel forum!

Best to use a lookup table for this, neither range is linear:

Book1
	A	B	C	D	E	F	G
1	Name	Performance	Payout			Performance	Payout
2	A	91%	50%			90%	50%
3	B	96%	80%			92%	60%
4	C	107%	130%			94%	70%
5	D	99%	90%			96%	80%
6	E	102%	110%			98%	90%
7						100%	100%
8						101%	110%
9						103%	130%
10						105%	150%
11
Sheet14

Cell Formulas
Range	Formula
C2:C6	C2	=VLOOKUP(B2,$F$2:$G$9,2)