SERIESSUM

returns the sum of a power series · from excel · excel: verified match · sheets: verified match

signature

SERIESSUM(x, n, m, coefficients)

returns: number

argumentrequired
x required
n required
m required
coefficients required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

A
1 10
2 20
3 30
fx =SERIESSUM(2, 0, 1, A1:A3) 170

errors

error values observed from the engine — each with a call that produces it.

errorproduced by
#ERROR! =SERIESSUM(1,0,1)
#NUM! =SERIESSUM(1E300,1000,1,A1)

related

  • ABS returns absolute value of a number
  • ACOS returns arccosine of a number
  • ACOSH returns inverse hyperbolic cosine
  • ACOT returns the arccotangent of a number
  • ACOTH returns the inverse hyperbolic cotangent
  • ADD adds two numbers — sheets exposes the + operator as a function