INTERCEPT Function
Returns where the best-fit straight line crosses the y-axis.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
INTERCEPT fits the least-squares straight line through your points and returns its value when x is 0.
With SLOPE you can predict any y: intercept + slope × x. Be careful reading the intercept on its own when x = 0 is far outside your data.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| known_y's | Yes | The values you want to predict (for example, sales). |
| known_x's | Yes | The values that drive them (for example, ad spend), the same size as known_y's. |
Examples
Example 1 — Baseline sales with no advertising
The same eight months.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Month | Ad spend ($k) | Sales ($k) | Measure | Result |
| 2 | Jan | 2 | 21 | Intercept | 12.2143 |
| 3 | Feb | 3 | 25 | Slope | 4.1071 |
| 4 | Mar | 5 | 33 | At $10k | 53.29 |
| 5 | Apr | 4 | 28 | ||
| 6 | May | 6 | 38 | ||
| 7 | Jun | 7 | 40 | ||
| 8 | Jul | 8 | 46 | ||
| 9 | Aug | 5 | 31 |
The line suggests about $12.2k of sales at $0 ad spend — but spend was never below $2k, so treat that as a rough extrapolation. The last row predicts sales for $10k of advertising.
Common mistakes
- y first, then x. Swapping the ranges fits a different line: =SLOPE(B2:B9,C2:C9) gives about 0.24 (ad spend per $1k of sales), not 4.11.
- #DIV/0! All the x values are the same, so no line can be fitted.
- #N/A The two ranges are different sizes.
Notes
- FORECAST.LINEAR does intercept + slope × x in one step.
- Related functions: SLOPE, FORECAST.LINEAR, TREND, LINEST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.