Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
FORECAST
FORECAST calculates a predicted y-value for a given x using simple linear regression on known data pairs. Use it to project future sales, revenue, or any numeric outcome when you have a set of historical paired observations and a target x-value.
Excel
=FORECAST(7,B2:B5,A2:A5)Google Sheets
=FORECAST(7,B2:B5,A2:A5)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify your known y-values (dependent variable) and known x-values (independent variable) in two parallel ranges.
- 2Choose the new x-value for which you want a predicted y.
- 3Enter =FORECAST(new_x, known_ys, known_xs) and the function returns the linear regression estimate.
Need a version for your data?
Try: “Predict next month's sales based on historical month numbers and sales figures”