ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   forecast function (https://www.excelbanter.com/excel-discussion-misc-queries/12829-forecast-function.html)

uriel78

forecast function
 
Is there a way to use forecast function(x;y_known;x_known) defining x_known
and y_known as two rows of values increasing from 0 until a maxvalue and
then going back to 0, by stopping the forecasting in the interval 0,max?

x_known =A1:Amax
y_known B1:Bmax




All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com