INTERCEPT Excel Function

The INTERCEPT Excel function is a regression line plotted as a result of the intersection based on known x and y-values. It calculates the value of the dependent variable when the independent variable is equal to zero.

Syntax of the INTERCEPT function is =INTERCEPT(known_ys,known_xs)
We will calculate the output using the INTERCEPT() for the time & distance values.

In the table, the data is,
• Column A contains the known_ys.
• Column B contains the known_xs.



The procedure to calculate the regression by the INTERCEPT formula is,

Select cell C14, enter the formula =INTERCEPT(A2:A4,B2:B4), and press the “Enter” key. The calculated result is “-219.576”, as shown below, also the graphical representation.

We can insert the INTERCEPT function as follows:

1. Select an empty cell for the output.
2. Type =INTERCEPT( in the selected cell. [Alternatively, type =I or =IN and double-click the INTERCEPT function from the list of suggestions shown by Excel.]
3. Enter the arguments as cell values or cell references and close the brackets.
4. Press the “Enter” key.

For example, the image depicts the time & distance values in columns A & B. We will calculate the output using the INTERCEPT function.
In the table, the data is,

• Column A contains the known_ys.
• Column B contains the known_xs.



The procedure to calculate the regression by the INTERCEPT formula is,

Select cell C14, enter the formula =INTERCEPT(A2:A4,B2:B4), and press the “Enter” key. The calculated result is “7.1129”, as shown below, also the graphical representation.

The INTERCEPT function is found in the “Formulas” tab, as shown below.

Choose an empty cell for the output → select the “Formulas” tab → go to the “Function Library” group → click the “More Function” option drop-down → click the “Statistical” option right arrow → select “INTERCEPT” function, as shown below.