The SERIESSUM function returns the sum of a power series, based on the following power series expansion:

    \[ \text{SERIESSUM}(x,n,m,a=a_1x^n+a_2x^{(n+m)}+a_3x^{(n+2m)}+ \dotso +a_jx^{(n+(j-1)m)} \]

Syntax

=SERIESSUM(x,n,m,coefficients)

Arguments

Argument Description
x The input value to the power series
n The initial power, to which x is to be raised
m The step size that n is increased by, on each successive power of x
coefficients An array of coefficients that multiply each successive power of x

The number of values in the supplied coefficients array defines the number of terms in the power series.

Examples

  A B C
1 Formula Results Notes
2 =SERIESSUM(5,1,1,{1,1,1,1,1}) 3905 Calculate series: 51+52+53+54+55
3 =SERIESSUM(2,1,2,{1,2,3,4,5}) 3186  Calculate series: 1*21+2*23+3*25+4*27+5*29
4 =SERIESSUM(“5”,1,1,{1,1,1,1,1}) #VALUE! Error occurs if any of the supplied arguments are non-numeric

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NAME! Occurs when Analysis ToolPak add-in is not enabled