SERIESSUM(x, n, m, coefficients)

Returns the sum of a power series based on a formula.

xThe input value to the power series.
nThe initial power to which you want to raise "x".
mThe step by which to increase "n" for each term in the series.
coefficientsThe set of coefficients by which each successive power of "x" is multiplied.

Remarks

* The number of values in coefficients determines the number of terms in the power series.
* If any of the arguments are not numeric, then #VALUE! is returned.
* For example, if there are three values in coefficients, then there will be three terms in the power series.
* In Excel 2007 the accuracy of this function was improved.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=SERIESSUM(2,0,2,{1,2}) = 9
2=SERIESSUM(2,0,2,{1,2,3,4}) = 313
3=SERIESSUM(3,0,2,{1,2,3,4}) = 3178
4=SERIESSUM("some text",0,2,{1,2,3,4}) = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top