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% |