IRR Array Lengths

G

Garry

Is there a maximum number of values in the IRR function
beyond which a #DIV0! error is returned in Excel 97 ?
 
F

Fred Smith

Not that we know of. The XIRR algorithm should be able to take an unlimited
number of values.

Your problem may be that the more entries, the more difficult it is for the
algorithm to converge to the correct result. So you may be seeing lack of
convergence errors. But a better guess will cure this problem.
 
Top