Excel functions / Math

SERIESSUM function

The sum of a power series: each coefficient times x raised to a power that grows by a fixed step.

Syntax

=SERIESSUM(x, n, m, coefficients)

Arguments

When to use it

SERIESSUM adds up a power series: each coefficient times x raised to a power that grows by a fixed step. It approximates functions such as sine or e from a few terms.

Examples

  1. Four terms of the series for cos(π/4)

    ABC
    1Coefficients
    210.70710
    3-0.5
    40.041666667
    5-0.001388889

    In C2: =SERIESSUM(PI()/4, 0, 2, A2:A5) → 0.70710

    Try this example

Common mistakes

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

Related functions