ExcelBanter - forecast function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - forecast function (https://www.excelbanter.com/excel-worksheet-functions/30911-forecast-function.html)

xtian5

forecast function

How can I use the Forecast function on non-adjacent columns to avoid having
to use the following equation.

=AVERAGE(L3,AB3,AR3)+((((3*((L3*1998)+(AB3*2001)+( AR3*2002)))-((L3+AB3+AR3)*(1998+2001+2002))))/((3*((1998^2)+(2001^2)+(2002^2)))-((1998+2001+2002)^2))*(2003-AVERAGE(1998,2001,2002)))

All times are GMT +1. The time now is 05:07 AM.