I know I could construct a quick sheet to build the series across a range of cells, but I'd like to be able to get the power series from an array formula in a single cell. (I can then nest this within another function, for example.)
The SERIESSUM
function works like this:
SERIESSUM(x,n,m,a) = a1x^n + a2x^(n+m) + a3x^(n+2m) + ... + ajx(n+(j-1)m)
Where the input a
is an array of coefficients, and j
is the length of a
.
The function I'm looking for would similarly return
[a1x^n, a2x^(n+m), a3x^(n+2m), ..., ajx(n+(j-1)m)]
This could either be a function that I haven't found, or a full array formula that results in the same output.
Any help would be greatly appreciated, thanks.