Hi all

I have a formula that works if I change some the final value in the array,
please tell me if this number is a limitation in Excel or I am doing
something wrong in the formula

the array contains the following numbers

-42,742,752
0
10,168,420
11,238,780
2,675,900
0
2,675,900
5,351,800
2,675,900
0
2,675,900
0
0
0
0
3,211,080
0
0
1,070,360
0
0
0
0
0
0
0
0
1,070,360
0
0
0
0
0
0
0
0
0
0
0
535,180
1,444,986
0
963,324
0
1,155,989
0
1,016,842
401,385
428,144
0
0
0
1,391,468
0
0
588,698
1,016,842
0
0
0
-12,443,805

The formula is
=(1+IRR(I96:I156,0.1))^12-1

I get the #NUM error
If I change the last value in the array to -9,400,000 I get a result, so I
know that my formula is correct, but anything over that number I get the #NUM
error.

Please let me know if there is something that can be done to make this
formula work with this number.

thanks
Tracy