July 3, 2022

# How to use the Excel SERIESSUM function

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( xnmcoefficients )

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.

READ:  How to use the Excel PI function #### Excel

View all posts by Excel →