compute values in a range

J

Julie

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?
 
B

Bob Phillips

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)
 
D

Dave R.

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.
 
Top