Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
INTERCEPT
INTERCEPT finds where the best-fit line crosses the y-axis — the predicted y-value when x equals zero. It is typically used alongside SLOPE to fully define the regression equation (y = slope * x + intercept) for forecasting or analysis purposes.
Excel
=INTERCEPT(B2:B5,A2:A5)Google Sheets
=INTERCEPT(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
- 1Organize your y-values and x-values in two parallel ranges of equal length.
- 2Enter =INTERCEPT(known_ys, known_xs) to compute the y-axis crossing point of the regression line.
- 3Combine with SLOPE to reconstruct the full linear equation: y = SLOPE * x + INTERCEPT.
Need a version for your data?
Try: “Find the baseline revenue when zero units are sold based on historical data”