FORECAST function
Summary
Returns a value along a linear trend This function has been replaced with FORECAST.LINEAR as part of the new Forecasting, but it's still available for compatibility with earlier versions.
Syntax
FORECAST.LINEAR(x, known_y's, known_x's)
- or -
FORECAST(x, known_y's, known_x's)
The FORECAST/FORECAST.LINEAR function syntax has the following arguments:
Argument | Required | Refers to
x | yes | The data point for which you want to predict a value.
known_y's | yes | The dependent array or range of data.
known_x's | yes | The independent array or range of data.
FORECAST(x, known_y's, known_x's)
The FORECAST/FORECAST.LINEAR function syntax has the following arguments:
Argument | Required | Refers to
x | yes | The data point for which you want to predict a value.
known_y's | yes | The dependent array or range of data.
known_x's | yes | The independent array or range of data.
Example
=FORECAST.LINEAR(30,A2:A6,B2:B6)