SERIESSUM Function in Excel returns the sum of power series as shown below
Syntax of SERIESSUM function in Excel
SERIESSUM( x, n, m, coefficients )
x | The input value to the power series. |
n | The first power to which x is to be raised. |
m | The value to be added with n, on each successive power of x. |
coefficients | coefficient of x |
Example of SERIESSUM function in Excel
Let’s generate a series of sum of 3
31 + 32 + 33 + 34
Formula
Result:
Example of SERIESSUM Function with coefficients
Let’s generate a series of sum of 3 with coefficients
1*31 + 2*32 + 3*33 + 4*34