How to Use the SERIESSUM Function in Google Sheets to Calculate Power Series Expansions

When modelling complex engineering formulas, financial cash flow polynomials, or evaluating Taylor and Maclaurin mathematical series in Google Sheets, calculating power series expansions manually requires cumbersome multi-column calculations or complex nested exponentiation formulas. Google Sheets provides a dedicated, highly efficient mathematical function designed specifically for this purpose: SERIESSUM.

The SERIESSUM function calculates the sum of a power series based on the formula: Sum = a1*x^n + a2*x^(n+m) + a3*x^(n+2m) + ... + ai*x^(n+(i-1)*m), where coefficients are dynamically applied across stepping powers.

Syntax and Argument Specifications

The formula structure for SERIESSUM requires four positional arguments:

=SERIESSUM(x, n, m, coefficients)

Each parameter defines a critical element of the polynomial power series:

• x: The base input value to the power series.
• n: The initial starting power to which x is raised in the first term.
• m: The power step increment added to the exponent for each subsequent term.
• coefficients: The range or array of multiplying constants ({a1, a2, a3, ...}) applied sequentially to each power term. The total number of terms evaluated equals the number of coefficients provided.

Mathematical Logic: How SERIESSUM Evaluates Terms

Suppose you specify x = 2, initial power n = 1, power increment m = 2, and coefficients {3, 5, 2}. The function expands and sums three distinct terms:

Term 1: 3 * (2^1)       = 3 * 2   = 6
Term 2: 5 * (2^(1+2))   = 5 * 2^3 = 5 * 8  = 40
Term 3: 2 * (2^(1+2+2)) = 2 * 2^5 = 2 * 32 = 64
Total Sum: 6 + 40 + 64  = 110

Benchmark Applications Matrix

The table below summarizes common scientific, statistical, and financial applications for SERIESSUM:

Analytical Domain	Mathematical Expansion	SERIESSUM Parameters	Use Case
Taylor Series (Cosine)	cos(x) = 1 - x^2/2! + x^4/4! - x^6/6!	n=0, m=2, alternating factorial coefficients	Approximating trigonometric functions in custom embedded formulas.
Compound Financial Annuity	Present Value of stepping cash flows	n=1, m=1, discounted cash flow coefficients	Valuing non-uniform future revenue streams.
Polynomial Regression	y = a0 + a1*x + a2*x^2 + a3*x^3	n=0, m=1, regression weight array	Evaluating fitted curve models directly from LINEST outputs.
Exponential Growth	e^x = 1 + x + x^2/2! + x^3/3!	n=0, m=1, inverse factorial array	Simulating biological or viral propagation thresholds.

Step-by-Step Implementation: Approximating the Exponential Function

To demonstrate the accuracy of SERIESSUM, let us approximate e^2 using the first five terms of the Maclaurin expansion:

1. In cell A1, enter the base value: 2.
2. In cells B1:B5, populate the inverse factorial coefficients (1/0!, 1/1!, 1/2!, 1/3!, 1/4!):

   B1: 1
   B2: 1
   B3: 0.5
   B4: 0.16666667
   B5: 0.04166667

3. In cell C1, evaluate the power series expansion:

   =SERIESSUM(A1, 0, 1, B1:B5)

   Result: approximately 7.2667.

4. Compare this to the true exponential value using Google Sheets’ built-in function:

   =EXP(A1)

   True value: 7.3891. Adding additional terms to the coefficient range rapidly converges on the exact figure.

Frequently Asked Questions

Can the step increment (m) be negative?

Yes. If you are modelling Laurent series or negative power decays, you can supply a negative integer for m (such as -1 or -2) to decrease exponents across terms.

What happens if the coefficients range contains blank cells?

Google Sheets treats blank cells within the coefficient range as zeros. The corresponding term evaluates to zero and does not disrupt the power sequence.