So many commas
Alan wrote...
....
=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.
|