| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill in data range knowing start and end values
I am trying to extrapolate a payout curve. I know payouts start at a 95%
index. The payout at that level is 25%. A 100% index yields a 100% payout. How do I determine the values in between? I know I have done this once before. Since it has been about a year, I have forgotten how to do this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fill in data range knowing start and end values
wouldn't it be
=(100%-25%)/(100-95) = 15% per index point? "Julie" wrote: I am trying to extrapolate a payout curve. I know payouts start at a 95% index. The payout at that level is 25%. A 100% index yields a 100% payout. How do I determine the values in between? I know I have done this once before. Since it has been about a year, I have forgotten how to do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
