WorksheetFunction.SeriesSum Method

  • Article

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)

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function SeriesSum ( _
    Arg1 As Object, _
    Arg2 As Object, _
    Arg3 As Object, _
    Arg4 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim Arg3 As Object
Dim Arg4 As Object
Dim returnValue As Double

returnValue = instance.SeriesSum(Arg1, _
    Arg2, Arg3, Arg4)

double SeriesSum(
    Object Arg1,
    Object Arg2,
    Object Arg3,
    Object Arg4
)

Parameters

  • Arg1
    Type: System.Object

    X - the input value to the power series.

  • Arg2
    Type: System.Object

    N - the initial power to which you want to raise x.

  • Arg3
    Type: System.Object

    M - the step by which to increase n for each term in the series.

  • Arg4
    Type: System.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.

Return Value

Type: System.Double

Remarks

If any argument is nonnumeric, SeriesSum returns the #VALUE! error value.

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace