by The SERIESSUM function is one of the math and trigonometry functions. It is used to return the sum of a power series. based on the following power series expansion:
Syntax: =SERIESSUM( x, n, m, coefficients )
The SERIESSUM function syntax has the following arguments:
| x | – | The input value to the power series. |
| n | – | The first power to which x is to be raised. |
| m | – | The step size that n is increased by, on each successive power of x. |
| coefficients | – | An array of coefficients that multiply each successive power of x. |
Example: Let’s look at some Excel SERIESSUM function examples and explore how to use the SERIESSUM function as a worksheet function in Microsoft Excel:
In the spreadsheet below, the Excel Seriessum function is used to calculate the power series:
Syntax: =SERIESSUM(5,1,1,{1,1,1,1,1})
Result:
Based on the Excel spreadsheet above, the following SERIESSUM examples would return:
Syntax: =SERIESSUM(7,1,1,{1,1,1,1,1})
Result: 19607
Syntax: =SERIESSUM(12,1,1,{1,1,1,1,1})
Result: 271452
Syntax: =SERIESSUM(2,1,2,{1,2,3,4,5})
Result: 3186
Syntax: =SERIESSUM(4,1,3,{1,3,5,7,9})
Result: 611402500
Syntax: =SERIESSUM(3,1,4,{1,2,3,4,5})
Result: 652137645
Syntax: =SERIESSUM(3,1,1,{1,1,1,1})
Result: 120
Syntax: =SERIESSUM(6,1,2,{1,2,3,4})
Result: 1143510
Syntax: =SERIESSUM(2,1,3,{1,1,1,1})
Result: 1170
Syntax: =SERIESSUM(3,1,1,{1,2,3,4})
Result: 426
Note: If any argument is nonnumeric, SERIESSUM returns the #VALUE! error value.
