Using SERIESSUM
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
|