compute values in a range
 

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?

Create a 4x2 table in say M1:N4 of

Amount Payout
0% 25%
97% 100%
101% 200%


and then use

=VLOOKUP(A1,M1:N4,2)

to calculate the payout

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Julie" wrote in message
...
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?

Maybe I misunderstand what you want to do, but if you are trying to be able
to compute payout for a certain amount based on these data points, you can
plot this as a scatter plot with a line. Then add a trendline and in
trendline properties select "display equation".

The equation it gives for your data set is: (substituted A1 for x)
=(15.726*A1)-1480

It is not super accurate, but if you only have 3 pairs of data, its not bad.
It returns:
29.696
92.6
202.682


for your 3 original Xs.




"Julie" wrote in message
...
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?

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?