![]() |
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. |
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. |
All times are GMT +1. The time now is 02:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com