On Sep 22, 12:14 am, Shailendra Harri
wrote:
"bj" wrote:
assuming you want a ten percent increase each year based
on that years payment to get the first payment
=5000/sumproduct(1.1^(row(A1:A5)-1)))

I have figured out that the formula you suggested must always start in row
1, since row A1 = 1 and using the formula in any other row will result in
incorrect calcuation.

Notwithstanding the fact that the formula is overkill, you might have
run into a problem if you copy-and-pasted the formula. The relative
range A1:A5 should be written as an absolute range, namely:

=5000/sumproduct(1.1^(row($A$1:$A$5)-1))

In this context, row($1:$5) always works.