From ZCubes Wiki
Jump to navigation Jump to search
SERIESSUM (x,n,m,coefficients)

  • is the power series value.
  • is the initial power value.
  • is the step value to increase the n value for each term.
  • is the set of coefficients by which each successive power of x is multiplied.
    • SERIESSUM(), returns the sum of a power series based on the formula.


  • This function gives the value of the seriessum of the given set of values.
  • Seriessum is defined by the following formula : .
  • Here is the power-series value, is the starting power value, is the increasing value of a power and is the set of coefficients.
  • According to the number of coefficients, the number of terms of the power series also get varies.
  • For example there 5 values in coefficients, then 5 terms will be there in power series.
   This function will give the result as error when any one of the argument is non-numeric.


  1. =SERIESSUM(3,2,2,[1,2,3,4,5,6]) = 3512493
  2. =SERIESSUM(1,0,4,[1,2,3]) = 6
  3. =SERIESSUM(2,1,5,[2,4,6,8]) = 536836
  4. =SERIESSUM(0,2,4,[1,2,3,4,5]) = 0
  5. =SERIESSUM(1,0,3,[1,2,3,4,5]) = 15
  6. =SERIESSUM(1,1,5,[1]) = 1

Related Videos


See Also