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.

* 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.
* For the Microsoft documentation refer to
* For the Google documentation refer to

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!

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