Excel functions / Math
SERIESSUM function
The sum of a power series: each coefficient times x raised to a power that grows by a fixed step.
Syntax
=SERIESSUM(x, n, m, coefficients)
Arguments
x: The value the series is worked out for.n: The power of x in the first term.m: How much the power grows from one term to the next.coefficients: What each power of x is multiplied by: one term for each coefficient.
When to use it
SERIESSUM adds up a power series: each coefficient times x raised to a power that grows by a fixed step. It approximates functions such as sine or e from a few terms.
Examples
Four terms of the series for cos(π/4)
A B C 1 Coefficients 2 1 0.70710 3 -0.5 4 0.041666667 5 -0.001388889 In C2:
=SERIESSUM(PI()/4, 0, 2, A2:A5)→ 0.70710
Common mistakes
- Too few terms. A series needs enough terms for the x used: far from 0, four terms are not enough.
SERIESSUM in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SERIESSUM
- Danish: SERIESUM
- Dutch: SOM.MACHTREEKS
- Finnish: SARJA.SUMMA
- French: SOMME.SERIES
- German: POTENZREIHE
- Hungarian: SORÖSSZEG
- Italian: SOMMA.SERIE
- Norwegian: SUMMER.REKKE
- Polish: SUMA.SZER.POT
- Portuguese (Brazil): SOMASEQÜÊNCIA
- Portuguese (Portugal): SOMASÉRIE
- Russian: РЯД.СУММ
- Spanish: SUMA.SERIES
- Swedish: SERIESUMMA
- Turkish: SERİTOPLA
Try SERIESSUM in the playground
Related functions
- SUMPRODUCT: Multiplies matching items in arrays, then adds the results.
- POWER: Raises a number to a power (same as ^).
- EXP: e raised to a power.