ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   fill in data range knowing start and end values (https://www.excelbanter.com/excel-worksheet-functions/88130-fill-data-range-knowing-start-end-values.html)

Julie

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.

Duke Carey

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