Statistical
INTERCEPT Function in Excel
Returns the y-intercept of the linear regression line.
Syntax
- =INTERCEPT(known_y's, known_x's)
Arguments
- known_y's (required): Dependent data range
- known_x's (required): Independent data range
Examples
- =INTERCEPT(B2:B10, A2:A10) - Y-intercept of trend line - Result: Intercept value
INTERCEPT for data analysis
- Confirm whether you need entire columns, filtered subsets, or distinct values.
- Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
- Pivot tables complement single-cell statistical formulas for exploration.
Common errors
- Arrays must be same size
Use cases
- Baseline value
- Regression analysis
- Trend starting point
Frequently asked questions
- What is INTERCEPT in Excel? INTERCEPT calculates the y-intercept of a linear regression line - where the trend line crosses the y-axis (when x=0). Combined with SLOPE, you can build the equation y = mx + b where INTERCEPT gives you 'b'.
- How do I create a trend line equation with INTERCEPT and SLOPE? Use =SLOPE(y_values, x_values) for 'm' and =INTERCEPT(y_values, x_values) for 'b'. The equation is y = mx + b. To predict y for any x: =SLOPE()*x + INTERCEPT(). Or use FORECAST.LINEAR directly.
- What does a negative INTERCEPT mean? A negative intercept means the trend line crosses the y-axis below zero. For example, if analyzing sales vs. advertising spend, a negative intercept might indicate baseline costs before any sales occur. The intercept's meaning depends on your data context.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.