Returns the sum of a power series based on the formula: x^n + m*x^(n+m) + m^2*x^(n+2m) + ...
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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.
=SERIESSUM(2, 1, 1, {1, 2, 3})結果: 26
Calculates 1*(2^1) + 2*(2^2) + 3*(2^3) = 2 + 8 + 24 = 26.
The function will return a #VALUE! error.