Predict a future number from a trend in your historical data.
Copy this formula
=FORECAST.LINEAR(x, known_ys, known_xs)FORECAST.LINEAR fits a straight-line trend through your known x/y pairs and projects the y for a new x. Use it for simple sales or demand projections where the trend is roughly linear.
=FORECAST.LINEAR(13, B2:B13, A2:A13)→1,540Projects month 13 from 12 months of data.
Linear forecasting will be inaccurate. Use FORECAST.ETS for seasonal data, or a chart trendline to check the shape first.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.