Syntax
SERIESSUM(x, n, m, coefficients)
| Parameter | Description |
|---|---|
| x | Parameter of the SERIESSUM function. |
| n | Parameter of the SERIESSUM function. |
| m | Parameter of the SERIESSUM function. |
| coefficients | Parameter of the SERIESSUM function. |
Examples
Polynomial evaluation
Formula
=SERIESSUM(2, 0, 1, {3,1,4})
Returns 3×2⁰ + 1×2¹ + 4×2² = 3 + 2 + 16 = 21. Evaluates the polynomial 3 + x + 4x² at x=2.
Even powers only
Formula
=SERIESSUM(3, 0, 2, {1,1,1})
Returns 1×3⁰ + 1×3² + 1×3⁴ = 1 + 9 + 81 = 91. Using m=2 evaluates only even powers.
Coefficients from cells
Formula
=SERIESSUM(A1, 0, 1, B1:B5)
Evaluates a 4th-degree polynomial at the value in A1, using B1:B5 as coefficients. Useful for curve fitting results.
Common Errors
#VALUE!
All arguments must be numeric. Non-numeric values in x, n, m, or the coefficients array return #VALUE!.
#NUM!
Can occur if the power series computation overflows or produces undefined values.
Tips
Taylor series approximation
Compute sin(x) ≈ x - x³/6 + x⁵/120 using =SERIESSUM(x, 1, 2, {1, -1/6, 1/120}) for a quick approximation.
Coefficients define the polynomial
The coefficient array is the polynomial's coefficients in order. For ax² + bx + c evaluated at x, use =SERIESSUM(x, 0, 1, {c, b, a}).
m controls step size
m=1 for consecutive powers (x⁰, x¹, x²...). m=2 for every other power (x⁰, x², x⁴...). This models even/odd-only series.
Try SERIESSUM in Viztab
Import your data and use SERIESSUM with 370+ other formulas. No signup required.
Open Viztab