ExcelBanter - Using SERIESSUM

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using SERIESSUM (https://www.excelbanter.com/excel-worksheet-functions/8020-using-seriessum.html)

I'm trying to get this formula to work in the SERIESSUM function.

=((100 * (1.02)^2 * 20) + (100 * (1.02) * 20) + (100 * 20)) / 60
=((100 * 20) * ((1.02)^2 + (1.02)^1 + (1.02)^0))) / 60
=102.0133

is now...
Where B1 = 100, B2 = 60, b3 = .02, and b4 = 3

=SERIESSUM((1 + B3),0,1,(B1 * B2 / B4)) / B2
=33.33 **not what I expected**

Help me understand ..
Thanks,
Steve

It appears that the last argument in seriessum needs to be a range. In your
example you're just getting the first term. Set up a column with (1/3) in
all the cells and use that for your final parameter. You'd want 3 cells for
your example.

Art

"Steve" wrote:

I'm trying to get this formula to work in the SERIESSUM function.

=((100 * (1.02)^2 * 20) + (100 * (1.02) * 20) + (100 * 20)) / 60
=((100 * 20) * ((1.02)^2 + (1.02)^1 + (1.02)^0))) / 60
=102.0133

is now...
Where B1 = 100, B2 = 60, b3 = .02, and b4 = 3

=SERIESSUM((1 + B3),0,1,(B1 * B2 / B4)) / B2
=33.33 **not what I expected**

Help me understand ..
Thanks,
Steve