try
=if(X1<.96,0,if(X1=1.07,2,if(X1<1,.25+.75*(X1-.96),1+1*(1.07-1))))

"Julie" wrote:

I am trying to compute a payout curve based on the following:

Amount Payout
96% 25%
100% 100%
107% 200%

With those three data points, how do I determine the payouts on all the % in
between what would a 96.1%, 96.2%, etc payout be?