Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default non-contiguous cells as arguments to XIRR

My situation is this:

Row 6, from column D to column DT, is a set of dates in ascending order.
Columns D through AY are dates in 2006. Columns AZ through DT are dates in
2007. Cash flows are in rows 9 through 100 (one row for each investment).
EA9:EA100 has the December 31, 2006, values; EB9:EB100 has the December 31,
2007 values. EA6 is equal to the date December 31, 2006; EB6 is equal to the
date December 31, 2007.I would like to calculate the XIRR for 2007 by using
the inverse of the December 31, 2006 value as the first cash flow. I'm
trying to do it as, e.g.,

XIRR((-EA9,AZ9:DT9,EB9),(EA6,AZ6:DT6,EB6))

I'm getting a #VALUE error. Is there some means other than an extra set of
parentheses to specify that the set of references is to be treated as a
single argument?
Reply
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
Non-contiguous cells Kokomojo Excel Discussion (Misc queries) 2 November 6th 07 05:09 PM
counting cells that are 0 in a range of non-contiguous cells Mark Excel Worksheet Functions 9 March 14th 07 03:45 PM
XIRR and Non Contiguous Cells John Taylor Excel Discussion (Misc queries) 2 August 2nd 06 01:41 AM
XIRR non contiguous references tloano Excel Discussion (Misc queries) 2 May 7th 06 06:34 PM
XIRR with non contigous cells topola Excel Worksheet Functions 2 November 22nd 05 09:26 AM


All times are GMT +1. The time now is 04:13 AM.

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"