SERIESSUM

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.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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!


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