How to Use INTERCEPT() in Google Sheets

Description

Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).

How To Actually Use INTERCEPT() in Sheets

INTERCEPT(data_y, data_x)

Try INTERCEPT yourself

Use the INTERCEPT formula to find the y-intercept of the data in the ranges B1:B10 (data_y) and A1:A10 (data_x). The correct answer should be placed in cell D1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the INTERCEPT() formula:

Generate a INTERCEPT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses INTERCEPT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a INTERCEPT() formula