FORECAST
Calculates a future value by using existing values. Replaced by FORECAST.LINEAR.
Syntax
FORECAST(x, known_y's, known_x's)
Parameters
- x: Required. The data point for which you want to predict a value
- known_y's: Required. The dependent array or range of data
- known_x's: Required. The independent array or range of data
Example
=FORECAST(30, A1:A10, B1:B10)