Excel functions / Statistics

GROWTH function

Values on the best-fit exponential curve: predictions for something that grows by a steady percentage rather than a steady amount. Spills.

Syntax

=GROWTH(known_y, [known_x], [new_x], [const])

Arguments

When to use it

GROWTH predicts values for something that grows by a steady percentage: it fits an exponential curve to the numbers you have and reads new values off it. TREND and FORECAST do the same with a straight line, for things that grow by a steady amount.

Give it the known values, the known periods, and the periods to predict.

Examples

  1. Next month, for sales that grow 10% a month

    ABCD
    1MonthSales
    2110001464.1
    321100
    431210
    541331

    In D2: =GROWTH(B2:B5, A2:A5, 5) → 1464.1

    Try this example

  2. What a straight line would have said

    ABCD
    1MonthSales
    21100028.1
    321100
    431210
    541331

    In D2: =GROWTH(B2:B5, A2:A5, 5)-FORECAST(5, B2:B5, A2:A5) → 28.1

    The curve is ahead of the line, and the gap widens every month.

    Try this example

Common mistakes

GROWTH 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 GROWTH in the playground

Related functions