So many commas

[Alan]

I need to find the present value of rental income that is discounted
at 5%. I need to show each year separately but when I do the formula,
I believe I have to put in a comma for each year past the first year.
By the time I am up to the row that has year 50, I have 49 commas.

=NPV($F$8,,,,,,F22) = that is my entry for year six. Is there any way
to put the year # into the equation. I have Excel 2003 and I don't
know how to use visual basic. What can I do?

 

[Harlan Grove]

=NPV($F$8,,,,,,F22) = that is my entry for year six. . . .

....

Or you could use

=F22*(1+$F$8)^-6

And if year 1 were in F17, year 2 in F18, etc. and your results were
in, say, column H, you could use formulas like

H17: (year 1)
=F17*(1+$F$8)^-ROWS(H$17:H17)

and fill H17 down as far as needed.

 

[Harlan Grove]

=NPV($F$8,,,,,,F22) = that is my entry for year six. . . .

....

Or you could use

=F22*(1+$F$8)^-6

And if year 1 were in F17, year 2 in F18, etc. and your results were
in, say, column H, you could use formulas like

H17: (year 1)
=F17*(1+$F$8)^-ROWS(H$17:H17)

and fill H17 down as far as needed.