View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AdmiralAJ AdmiralAJ is offline
external usenet poster
 
Posts: 18
Default Future Value Array Formula

I have to calculate the future value of several cost items that occur
from 2009 to 2013. Assume all costs are incurred Jan 1 of each
respective year. The current year is 2013. Does anyone know how to
do this? Here's a sample of what my data looks like:

D
E F G H
Year 2009 2010
2011 2012 2013
74 cost 1 $2,000,000 $2,000,000 $2,000,000
$2,000,000 $2,000,000
75 cost 2 1,000,000 1,000,000
1,000,000 1,000,000 1,000,000

I tried using the following formula but it did not work: FV(8%,2013-
(D73:H73),,-(D74:H74))

Any help would be appreciated.

AJ