Excel functions / Statistics

INTERCEPT function

Where the best-fit straight line crosses the y axis: the predicted y when x is 0.

Syntax

=INTERCEPT(known_y, known_x)

Arguments

When to use it

INTERCEPT gives the point where the best-fit straight line crosses the y axis: the y value the line predicts when x is 0. Together with SLOPE it describes the whole line, y = intercept + slope × x.

Like SLOPE, it takes y first, then x.

Examples

  1. Baseline sales

    ABCD
    1Ad spendSales
    21012069.4
    315150
    420168
    525205
    630222

    In D2: =INTERCEPT(B2:B6, A2:A6) → 69.4

    Try this example

  2. A prediction from the line

    ABCD
    1Ad spendSales
    210120250.7
    315150
    420168
    525205
    630222

    In D2: =INTERCEPT(B2:B6, A2:A6)+SLOPE(B2:B6, A2:A6)*35 → 250.7

    Try this example

Common mistakes

INTERCEPT in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try INTERCEPT in the playground

Practise it

Related functions