Predict a future value from a linear trend.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
FORECAST.LINEAR(x, known_y's, known_x's)FORECAST.LINEAR fits a straight line through known x/y pairs and estimates the y value for a new x. Use it when the historical relationship is roughly linear.
=FORECAST.LINEAR(13, B2:B13, A2:A13)Result: 1540
Predicts month 13 from months 1-12.
Not well. Use it for simple linear trends; seasonal patterns usually need a different model such as FORECAST.ETS.