FORECAST.LINEAR function
Summary
Returns a future value based on existing values
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
See Microsoft Support Site for Further details."