## How to use the INTERCEPT function

The INTERCEPT function returns a value representing the y-value where a line intersects the y-axis. The line is calculated using the method of least squares based on known x- and y-values.

Use the INTERCEPT function when you want to build a linear regression line based on this straight line equation y = mx + c. c is where the line cuts the y-axis, m is the slope of the line and can be calculated using the SLOPE function.

Formula in cell E3:

### Excel Function Syntax

INTERCEPT(*known_y's, known_x's*)

### Arguments

known_y's |
Required. An array or cell reference to dependent data points. |

known_x's |
Required. An array or cell reference to independent data points. |

### Comments

Zero values are included but text, logical values and empty cells are ignored.

The SLOPE function returns

- #N/A! error if there are a different number of values in
*known_y's*and*known_x's**.*

Equation for the INTERCEPT function:

Equation for b:

The following chart demonstrates the x- and y-values used in the top image and where the fitted line intersects the y-axis which also corresponds to the value calculated by the INTERCEPT function.

### 'INTERCEPT' function examples

The following article has a formula that contains the INTERCEPT function.

Have you ever tried to build a formula to calculate discounts based on price? The VLOOKUP function is much easier […]

### 'INTERCEPT' function examples

The following 408 articles contain the INTERCEPT function.

This post explains how to lookup a value and return multiple values. No array formula required.

This article demonstrates how to extract records/rows based on two conditions applied to two different columns, you can easily extend […]

Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]

Question: How do i return multiple results for one lookup value? I have tried to use multiple vlookups, with no […]

First, let me explain the difference between unique values and unique distinct values, it is important you know the difference […]

In this blog post I will provide two solutions on how to remove blank cells and a solution on how […]

This article explains how to build dependent drop down lists. Here is a list of order numbers and products. We […]

This post demonstrates how to build an array formula that counts unique distinct values based on criteria. What's on this […]

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

Question: How do I create a random list of unique numbers from say 1 to 10, without using VBA and […]

Lookup with criteria and return records.

Question: I have two ranges or lists (List1 and List2) from where I would like to extract a unique distinct […]

Table of Contents Sort a column - Excel 365 Sort a column using array formula Two columns sorting by the […]

Question: How do I create a drop-down list with unique distinct alphabetically sorted values? Table of contents Sort values using […]

This article demonstrates formulas that extract the nearest number in a cell range to a condition. The image above shows […]

This article demonstrates array formulas that search for cell values containing a search string and returns corresponding values on the […]

Today I have two functions I would like to demonstrate, they calculate all possible combinations from a cell range. What […]

This article shows how to extract unique distinct values based on a condition applied to an adjacent column using formulas. […]

The array formula in cell D3 extracts unique distinct values sorted A to Z, from column B to column D. […]

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

## Functions in this article

### Functions in 'Statistical' category

The INTERCEPT function function is one of many functions in the 'Statistical' category.

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Paste image link to your comment.

Contact OscarYou can contact me through this contact form