# Documentation/Calc Functions/SERIESSUM

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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) = coefficient_{1}x^{n} + coefficient_{2}x^{(n+m)} + coefficient_{3}x^{(n+2m)} +...+ coefficient_{i}x^{(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:

## Equivalent Excel functions:

SERIESSUM