SERIESSUM
Returns the sum of a power series.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Number
Examples
=SERIESSUM(2, 0, 1, A1:A3) | A | |
|---|---|
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
Result 170
Syntax
SERIESSUM(x, n, m, coefficients) x- number required
n- number required
m- number required
coefficients- range required
Errors
#ERROR!=SERIESSUM(1,0,1)#NUM!=SERIESSUM(1E300,1000,1,A1)