LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic Future Value Formula & Interest Rate Formula Peter Excel Discussion (Misc queries) 2 November 12th 06 04:23 AM
Future Value formula heater Excel Discussion (Misc queries) 2 May 18th 06 12:11 AM
Formula to predict a future date Bill Eagle eye Excel Worksheet Functions 1 November 3rd 05 02:32 AM
Future date formula David Excel Discussion (Misc queries) 16 October 6th 05 01:46 AM
formula for age at future date MEJ Excel Discussion (Misc queries) 3 March 30th 05 12:30 AM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"