I need, for a loan amortization schedule, to calculate a sum like A^(i)*B^(n-i). I found the SERIESSUM function, but this seems to only apply to a standard power series of the form r^i. So how would I calculate something like 2^1*3^2 + 2^2*3^1 + 2^3*3^0 with a function in excel?
=sumproduct(2^row(indirect("1:3"))*3^(3-row(indirect("3:1"))))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
IN 2^1*3^2 + 2^2*3^1 + 2^3*3^0
If A1=2, B1=3,C1 = Number of terms
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks