Documentation/Calc Functions/SERIESSUM

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
English • ‎dansk



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 a real number or a reference to the cell containing that number which is the input value for the power series.

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

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

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

  • If X is negative, then N and M need 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 ) = coefficient1 xn + coefficient2 x(n+m) + coefficient3 x(n+2m) +...+ coefficienti x(n+(i-1)m)

Examples:

Formula Description Returns
=SERIESSUM(7;3;5;A4:A8) where A4:A8 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:A8) where A4:A8 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:A8) where A4:A8 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:A8) where A4:A8 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:A8) where A4:A8 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