Skip to content
Excel

SERIESSUM function in Excel

Returns the sum of a power series based on the formula

=SERIESSUM(x, n, m, coefficients)

SERIESSUM syntax and parameters

Four arguments, four required.

  • xnumberRequired

    The input value to the power series.

  • nnumberRequired

    The initial power to which you want to raise x.

  • mnumberRequired

    The step by which to increase n for each term in the series.

  • coefficientsarrayRequired

    A set of coefficients by which each successive power of x is multiplied. The number of values in coefficients determines the number of terms in the power series. For example, if there are three values in coefficients, then there will be three terms in the power series.

SERIESSUM examples

Formulas you'll actually reuse.

  1. A Taylor series for e^x — coefficients 1/n!, powers starting at 0 and stepping by 1:

    =SERIESSUM(B2, 0, 1, {1, 1, 0.5, 0.1667, 0.0417})

    Result2.7083

  2. A sine approximation — odd powers only (start 1, step 2):

    =SERIESSUM(B2, 1, 2, {1, -0.1667, 0.0083})

    Result0.8415

SERIESSUM in Google Sheets

Same name — your formula ports as-is.

Try SERIESSUM in the playground

Edit the example — nothing to install.

Preloaded with the SERIESSUM formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.