SERIESSUM

Formulas / SERIESSUM
Calculate the sum of a power series.
=SERIESSUM(x, n, m, coefficients)
  • x - The input value to the power series
  • n - The power x to which the first number is to be raised.
  • m - The step size that n is increased by, for each successive power of x.
  • coefficients - An array of coefficients that multiply each successive power of x.

Examples

  • =SERIESSUM(A3,0,2,A4:A7)

    In this example, the SERIESSUM function is used to approximate the cosine of Pi/4 radians. This can be done by using the formula above. The result of this formula is the sum of a power series based on the formula: x + N + M + C where C = PI()/4.

  • =SERIESSUM(A3,0,2,A4:A7)

    Another use of the SERIESSUM function is to calculate the sum of a series of numbers. For example, the formula can be used to calculate the sum of the series in cells A4 to A7.

  • =SERIESSUM(A3,0,2,A4:A7)

    The SERIESSUM function can also be used to calculate the sum of a series of numbers with a specific exponential factor. For example, the formula can be used to calculate the sum of the series in cells A4 to A7 with an exponential factor of 2.

  • =SERIESSUM(A3,0,2,A4:A7)

    The SERIESSUM function can also be used to calculate the sum of a series of numbers with a specific exponential factor and a constant. For example, the formula can be used to calculate the sum of the series in cells A4 to A7 with an exponential factor of 2 and the constant PI()/4.


Summary

The SERIESSUM function is a Sourcetable tool used to calculate the sum of a power series, making it easy to quickly and accurately determine the total of a set of values.

  • The SERIESSUM function is used to calculate the sum of a power series of the form: a + a1x + a2x2 + a3x3 + ... + anxn
  • The function has three arguments: x, n and m. x is the power series argument, n is the power of the series and m is the number of terms to be added.
  • The SERIESSUM function can be used to calculate the sum of an infinite series, as long as the terms of the series tend to zero as n tends to infinity.
  • The SERIESSUM function can be used to calculate the sum of a finite series, as long as the number of terms is known.
  • The SERIESSUM function can be used in combination with other Sourcetable functions, such as the SUM and SUMIF functions, to calculate the sum of a series of values.
  • The SERIESSUM function can be used to calculate the sum of a series of values that are stored in a range of cells.

Frequently Asked Questions

What is the SERIESSUM function?
The SERIESSUM function is used to calculate the sum of a power series. It uses the formula x = n * m * coefficients to calculate the series.
How is the SERIESSUM function used?
The SERIESSUM function takes three arguments:
  • The first argument is the coefficient of the series.
  • The second argument is the power of the series.
  • The third argument is the initial value of the series.
What are the benefits of using the SERIESSUM function?
Using the SERIESSUM function is an efficient way to calculate the sum of a power series. It is also easy to use, as it only requires three arguments.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV