Math and Trignometric SERIESSUM Function



Description

The SERIESSUM function returns the sum of a power series. Many functions can be approximated by a power series expansion.

Syntax

SERIESSUM (x, n, m, coefficients)

Arguments

Argument Description Required/Optional
X The input value to the power series. Required
N The initial power to which you want to raise x. Required
M The step by which to increase n for each term in the series. Required
Coefficients 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. Required

Notes

  • The sum of a power series is given by

    $SERIESSUM (x, n, m, a) = a_1x^n+a_2x^{(n+m)}+a_3x^{(n+2m)}+...+a_jx^{(n+(j-1)m)}$

    Where (a1, a2, a3 … aj) is the set of coefficients.

  • If any of the specified arguments is non-numeric, SERIESSUM returns #VALUE! error

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

SERIESSUM Function
advanced_excel_math_trigonometric_functions.htm
Advertisements