Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > SERIESSUM
 

SERIESSUM(x, n, m, coefficients)

 
 Returns the sum of a power series based on a formula.

 xThe input value to the power series.
 nThe initial power to which you want to raise x.
 mThe step by which to increase n for each term in the series.
 coefficientsThe set of coefficients by which each successive power of x is multiplied.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• The number of values in coefficients determines the number of terms in the power series.
     
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• For example, if there are three values in coefficients, then there will be three terms in the power series.

     EXAMPLES
     
     A
    1=SERIESSUM(2,0,2,{1,2}) = 9
    2=SERIESSUM(2,0,2,{1,2,3,4}) = 313
    3=SERIESSUM(3,0,2,{1,2,3,4}) = 3178
    4=SERIESSUM("some text",0,2,{1,2,3,4}) = #VALUE!
    		 
     Functions - S | Index - S | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top