,SeriesSum(X, Power, Step, Coefficients)
X. Value of power series variable.
Power. The X exponent for the first term of power series.
Step. The step, by which the Power exponent increases for each following power series term.
Coefficients. The range of cells, which values determine a set of coefficients for respective power of X. The number of values in the Coefficients parameter determines the number of power series terms.
NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.
It returns the sum of a power series.
The SeriesSum function value is determined with the following formula:
,
where:
a1, a2, …, ai. Set of coefficients. It corresponds to the Coefficients parameter.
n. It corresponds to the Power parameter.
m. It corresponds to the Step parameter.
| Formula | Result | Description |
| =SeriesSum(10, 1, 1, B6:D6) | 5046,58 | The sum of power series, which members are specified by the B6:D6 cell range. This range contains the following numbers: 124,658; -2; 4. |
See also:
Function Wizard │ Mathematical Functions