INTERCEPT Function Examples – Excel, VBA, & Google Sheets

This tutorial demonstrates how to use the INTERCEPT Function in Excel to calculate the y intercept.

What is the INTERCEPT Function?

The INTERCEPT function in Excel is used to calculate the y-intercept of a line given known x and y values.

The INTERCEPT function can be used in conjunction with the SLOPE function to find the equation of a linear line,

Suppose I have a table of data with x and y values:

The y-intercept of the line can be found by extending the of best fit backwards until it intercepts the y-axis:

Using the above chart, we find the intercept, a to be zero.

Using the INTERCEPT function:

How to use INTERCEPT

The INTERCEPT function takes two arguments:

=INTERCEPT(known_y’s, known_x’s)

Where known_y’s and known_x’s refer to the x and y data in your data table.

Using our first example, the function is written as:

=INTERCEPT(B3:B7,C3:C7)

Pairing SLOPE and INTERCEPT

To pair SLOPE and INTERCEPT, an equation can be written as:

=INTERCEPT(B3:B7,C3:C7) + SLOPE(B3:B7,C3:C7) * x

Interested in More Forecasting?

Pair INTERCEPT with SLOPE to see how to create the equation of a line and visit our other articles on Forecasting with Exponential Smoothing, TREND and LINEST functions.

GROWTH Function in Google Sheets

The GROWTH function works exactly the same in Google Sheets as in Excel.

INTERCEPT Examples in VBA

You can also use the INTERCEPT function in VBA. Type:

application.worksheetfunction.intercept(known_ys,known_xs)