Parameter List
Syntax
FORECAST(x, data_y, data_x)
x
The independent value x on which to base the forecast of y (e.g. a future date, for a time-series, or a numerical value, for a range of numbers)
data_y
The range of cells with the dependent data. For example: A1:A20.
data_x
The range of cells with the independent data. For example: B1:B20.