Help with Excel array functions - select, add & return result

C

clk008

hi, i've got the following data set for which I'm trying to find the
XIRR() result for data as of 31 Mar 2007.

Row \ Col A B C D
E F
1 Date Amt Adjustment 31/3/07 +80
2 1/1/06 -100
3 1/6/06 40
4 1/1/07 5
5 1/6/07 10
6 .... .....
7 .... .....

Notes -
1. The array / range that meets the 31 Mar 07 criteria is A1:B4 and
E1:F4 (adjustment value)
2. Adjustment value is in a separate place.

XIRR((($A$2:$A$5)*($A$2:$A$5<=DATE(2007,3,31))+OFFSET($F$2,0,0,ROWS($A
$2:$A$5),COLUMNS($A$2:$A$5))),((-1)*($B$2:$B$5)*($A$2:$A
$5<=DATE(2007,3,31))+OFFSET($G$2,0,0,ROWS($A$2:$A$5),COLUMNS($A$2:$A
$5))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top