Excel - Microsoft Excel Seriessum Function

Description

The Excel SERIESSUM function returns the sum of a power series, based on the following power series expansion: 

The syntax of the function is : 

SERIESSUM( x, n, m, coefficients ) 

Where the function arguments are: 

The number of values in the supplied coefficients array defines the number of terms in the power series. This is illustrated in the following example. 

Excel Seriessum Function Examples

Example 1

In the example below, the Excel Seriessum function is used to calculate the power series: 

51 + 52 + 53 + 54 + 55 

The formula is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right. 

Example 2

In the example below, the Excel Seriessum function calculates the power series: 

1 * 21 + 2 * 23 + 3 * 25 + 4 * 27 + 5 * 29 

Again, the formula is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right. 

Seriessum Function Errors

If you get an error from the Excel Seriessum Function, this is likely to be one of the following: 

Common Errors