Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to compute StDev of only nonzero entries in a range? | Excel Worksheet Functions | |||
How many values appear more than once in a range? | Excel Worksheet Functions | |||
Checking ALL values in a range | Excel Discussion (Misc queries) | |||
How to move Y-axis values when X range is -a to +b | Charts and Charting in Excel | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |