Syntax. INTERCEPT(known_y’s,known_x’s)

Definition. This function returns the intersection of the regression line (see Figure 12-124, in the discussion of the SLOPE() function).

The function calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on the best-fit regression line drawn through the known x-values and known y-values.


  • known_y’s (required). The dependent set of observations or data

  • known_x’s (required). The independent set of observations or data


Arguments can be numbers, names, arrays, or references containing numbers. If an array or a reference argument contains text, logical values, or empty cells, those values are ignored. Note that cells ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.