Funzione di Google Sheets

SERIESSUM

Returns the sum of a power series based on the formula: x^n + m*x^(n+m) + m^2*x^(n+2m) + ...

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

SERIESSUM(x, n, m, coefficients)

The SERIESSUM function calculates the sum of a power series. It is commonly used in mathematical modeling and engineering to evaluate polynomial functions or series expansions.

Argomenti

xobbligatorioThe input value for the power series.
nobbligatorioThe initial power to which x is raised.
mobbligatorioThe step by which to increase the power for each subsequent term.
coefficientsobbligatorioA range or array of coefficients by which each successive power of x is multiplied.

Esempi

=SERIESSUM(2, 1, 1, {1, 2, 3})

Risultato: 26

Calculates 1*(2^1) + 2*(2^2) + 3*(2^3) = 2 + 8 + 24 = 26.

Domande frequenti

What happens if the coefficients array is empty?

The function will return a #VALUE! error.

Funzioni correlate

SUM SUMPRODUCT POWER