WorksheetFunction.SeriesSum(Object, Object, Object, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns the sum of a power series based on the formula: SERIES(x,n,m,a)= a1xn+a2x(n+m)+a3x(n+2m)+…+aix(n+(i-1)m)
public:
double SeriesSum(System::Object ^ Arg1, System::Object ^ Arg2, System::Object ^ Arg3, System::Object ^ Arg4);public double SeriesSum (object Arg1, object Arg2, object Arg3, object Arg4);Public Function SeriesSum (Arg1 As Object, Arg2 As Object, Arg3 As Object, Arg4 As Object) As DoubleParameters
- Arg1
- Object
X - the input value to the power series.
- Arg2
- Object
N - the initial power to which you want to raise x.
- Arg3
- Object
M - the step by which to increase n for each term in the series.
- Arg4
- Object
Coefficients - a set of coefficients by which each successive power of x is multiplied. The number of values in coefficients determines the number of terms in the power series. For example, if there are three values in coefficients, then there will be three terms in the power series.
Returns
Remarks
If any argument is nonnumeric, SeriesSum returns the #VALUE! error value.