SERIESSUM

Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`. Learn more

Video field
Math

In Google Sheets, the SERIESSUM() function is used to calculate the sum of a power series based on the parameters provided. A power series is a mathematical series in the form of a0 + a1x^1 + a2x^2 + … + an*x^n, where "a" represents the coefficients and "x" is the variable.

The syntax for the SERIESSUM() function in Google Sheets is: SERIESSUM(x, n, m, a)

Here's what each parameter represents:

x: The value at which the power series is evaluated. n: The number of terms in the power series to include in the calculation. m: The initial power of "x" in the power series. a: The array or range of coefficients for the power series. Here's an example of how you can use the SERIESSUM() function in Google Sheets:

=SERIESSUM(A2, 5, 2, {1, 2, 3, 4, 5})

In this example, the formula calculates the sum of a power series evaluated at the value in cell A2. The power series includes 5 terms, starting with the power of x^2, and the coefficients are provided in the array {1, 2, 3, 4, 5}.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!