SERIESSUM function

SERIESSUM(x, n, m, coefficients) SERIESSUM(x; n; m; coefficients)

x

Number or { Number }

The input value for the power series.

n

Number or { Number }

The power of the input value for the first term.

m

Number or { Number }

The number that the n parameter is incremented by with each term.

coefficients

{ Number }

The coefficients by which each successive power of x is multiplied. The size of this array determines the number of terms in the power series.

Returns

Number or { Number }

The sum of the first terms of a power series.

Returns the sum of the first terms of a power series.

Examples

SERIESSUM(7, 3, 5, { 1, 4, 7, 10 })SERIESSUM(7; 3; 5; { 1; 4; 7; 10 })

Returns roughly 1.63E+16. This formula is equivalent to 1 * 7 ^ 3 + 4 * 7 ^ 8 + 7 * 7 ^ 13 + 10 * 7 ^ 18.

SERIESSUM(1, 0, 1, { 1/FACT(0), 1/FACT(1), 1/FACT(2), 1/FACT(3) })SERIESSUM(1; 0; 1; { 1/FACT(0); 1/FACT(1); 1/FACT(2); 1/FACT(3) })

Returns roughly 2.66667, an approximation of e (roughly 2.71828). Using more terms would give a closer approximation.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.