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))))
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))))