Thread: Using SERIESSUM
View Single Post
  #1   Report Post  
Steve
 
Posts: n/a
Default 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