Skip to content
Google Sheets

SERIESSUM function in Google Sheets

Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`.

=SERIESSUM(x, n, m, a)

SERIESSUM syntax and parameters

Four arguments, four required.

  • xnumberRequired

    The input to the power series. Varies depending on the type of approximation, may be angle, exponent, or some other value.

  • nnumberRequired

    The initial power to which to raise x in the power series.

  • mnumberRequired

    The additive increment by which to increase x.

  • aarrayRequired

    The array or range containing the coefficients of 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 Excel

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 Google Sheets gets this done.