Expand Minimize

WorksheetFunction.SeriesSum Method (Excel)

Returns the sum of a power series based on the formula:awfsrssm_ZA06051246

expression .SeriesSum(Arg1, Arg2, Arg3, Arg4)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Variant

X - the input value to the power series.

Arg2

Required

Variant

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

Arg3

Required

Variant

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

Arg4

Required

Variant

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

Double

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

Show:
© 2014 Microsoft