Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seriessum is not quite it...need help, please | Excel Worksheet Functions |