FORECAST()

FORECAST

Extrapolates future values based on existing x and y values.

Syntax

FORECAST(Value; DataY; DataX)

Value is the x value, for which the y value on the linear regression is to be returned.

DataY is the array or range of known y's.

DataX is the array or range of known x's.

Cells A2:A40 contain the x-values and cells B2:B40 contain the y-values.
Cell D2 contains Value.
Cell E2 contains the formula =FORECAST(D2;$B$2:$B$40;$A$2:$A$40)

Cells E3:E12 contains formulas similar to the formula in E2.

Below is a screen shot of my spreadsheet.

Note: Not all of the x- and y-values are shown in the screen shot.