Microsoft® Excel® 2010 Formulas & Functions Inside Out

SERIESSUM()

Syntax. SERIESSUM(x,n,m,coefficients)

Definition. SERIESSUM(x,n,m,{a₁,a₂,a₃,a₄,...,a_k}) returns the sum of a power series:

y = a₁xⁿ + a₂x^n+m + a₃x^n+2m + a₄x^n+3m +...+ a_kx^n+km

The number of values in coefficients determines the number of terms in the power series.

Arguments

• x (required) The value of the independent variable for the power series.

• n (required) The power of x in the first term.

• m (required) The increment for n.

• coefficients (required) An array of coefficients of the power series. 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.

Background. A power series is an infinite series in the ...