Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

INTERCEPT

Calculates the y-value at which a linear regression line based on a given dataset will intercept the y-axis.

Sample Usage

INTERCEPT(A2:A5, B2:B5)

Syntax

INTERCEPT(data_y, data_x)

  • data_y - The array or range representing dependent data points.
  • data_x - The array or range representing independent data points.

Examples

INTERCEPT(A2:A5, B2:B5) returns the point at which the line will intersect the y-axis by using the dataset in A2:A5 and B2:B5.

Notes

  • Any text encountered in data_y and data_x will be ignored.