Thread: So many commas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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.