SERIESSUM function
SERIESSUM adds up a polynomial or power series from a list of coefficients, as in Taylor expansions. The number of terms in the series equals the number of coefficients you give.
Example
Read it as a sentence: use 2 as x, starting at power 1 and going up by 2 for each value in AE1:AE3, multiply each value by its power of x, then add up the results, which gives -24.
Excel shows -24
AE
1
2
2
0.5
3
-1
Data
Syntax
SERIESSUM(x, n, m, coefficients)
-
x(required) - The input value of the series.
-
n(required) - The starting power of x.
-
m(required) - The step added to the power for each term.
-
coefficients(required) - The multipliers for each term.
Returns: The sum of a power series: a1*x^n + a2*x^(n+m) + ...
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SERIESSUM(1,0,1,{1,1,0.5,0.1666667}) | 2.6666667 | E approx |
=SERIESSUM("2",0,1,{1,1}) | 3 | Text number x |
=SERIESSUM(2,1,2,Data!AE1:AE3) | -24 | Range coeffs |
=SERIESSUM(1,0,1,Data!D1:D2) | 0 | Blank coeffs |
=SERIESSUM(0,0,1,{1,2}) | #NUM! | X 0, n 0 |
=SERIESSUM(0,-1,1,{1,2}) | #NUM! | X 0, n -1 |
=SERIESSUM(1,0,1,{1,"a"}) | #VALUE! | Text coeff |
=SERIESSUM("a",0,1,{1}) | #VALUE! | Text x |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
AE
1
2
2
0.5
3
-1
Data
Watch out for
- The number of terms equals the number of coefficients.
Where it works
- Excel
- SERIESSUM is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .