# INTERCEPT Function Examples – Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 9, 2023

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)``