SheetFX
≡
<< Go back to all functions

SERIESSUM

The SERIESSUM function in Google Sheets calculates the sum of a power series with given parameters. It is used to find the sum of terms in the form a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range a. This function is useful in various mathematical and financial applications.

Function Syntax and Parameters

Syntax: SERIESSUM(x, n, m, a)

Parameters:

  • x: The input value for the power series.
  • n: The exponent multiplier for the power series.
  • m: The increment multiplier for the power series.
  • a: The range of values that represent the coefficients of the power series.

Step-by-Step Tutorial

  1. Using SERIESSUM with specific values:

    • Example: =SERIESSUM(2, 3, 2, {1, 2, 3})
    • Result: The sum of the power series is calculated based on the values provided.

  2. Using SERIESSUM with cell references:

    • Example: If the input value is in cell A1, the exponent multiplier is in A2, the increment multiplier is in A3, and the coefficients are in the range A4:A7, then =SERIESSUM(A1, A2, A3, A4:A7) will return the sum of the power series.

Use Cases and Scenarios

  1. Financial Modeling: Calculate the total value of an investment based on a power series model.
  2. Engineering Analysis: Determine the cumulative effect of a recurring pattern over time.
  3. Mathematical Calculations: Find the sum of terms in a power series for various mathematical equations.

Related Functions

  • SUM: Calculate the sum of a range of cells.
  • POWER: Raise a number to a power.
  • SEQUENCE: Generate a sequence of numbers.

Related Articles