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?
Bookmarks