Documentation/Calc Functions/SERIESSUM

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

Function name:

SERIESSUM

Category:

Mathematical

Summary:

Sums the first terms of a power series.

Syntax:

SERIESSUM(X; N; M; Coefficients)

Returns:

Returns a real number which is the sum of the first terms of the given power series.

Arguments:

X is real number or a reference to the cell containing that number which is the input value for the power series.

N is real number or a reference to the cell containing that number which is the initial power.

M is real number or a reference to the cell containing that number which is the increment to increase N.

Coefficients is real number or a reference to the cell containing that number which is a series of coefficients. For each coefficient the series sum is extended by one section.

  • This function is predominately used for all integer arguments.
  • If X is negative, then N and M needs to be integral else the function returns an error value.
  • If X is 0, then N cannot be 0 else the function returns an value error (#VALUE!).

Additional details:

The formula for SERIESSUM is:

SERIESSUM(x;n;m;coefficients) = coefficient1xn + coefficient2x(n+m) + coefficient3x(n+2m) +...+ coefficientix(n+(i-1)m)

Examples:

Formula Description Returns
=SERIESSUM(7;3;5;A4:A7) where A4:A7 is 3,6,9,12,15 3*7^3+6*7^8+9*7^13+12*7^18+15*7^23 4.10550751936424E+020
=SERIESSUM(7.2;3.4;5.1;A4:A7) where A4:A7 is 3,-6,9.5,-12.7,15 3*7.2^3.4-6*7.2^8.5+9.5*7.2^13.6-12.7*7.2^18.7+15*7.2^23.8 3.8070543349058E+021
=SERIESSUM(-7;3;5;A4:A7) where A4:A7 is 3,6,9,12,15 3*(-7)^3+6*(-7)^8+9*(-7)^13+12*(-7)^18+15*(-7)^23 -4.10511670010005E+020
=SERIESSUM(-7;3.2;5;A4:A7) where A4:A7 is 3,6,9,12,15 negative number is raised to non-integer power so the function returns an error value Err:502
=SERIESSUM(0;0;5;A4:A7) where A4:A7 is 3,6,9,12,15 0 raised to the 0 so the function returns a value error #VALUE!

Related LibreOffice functions:

None

ODF standard:

Section 6.16.53, part2

Equivalent Excel functions:

SERIESSUM