IRR Array Lengths

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

Is there a maximum number of values in the IRR function
beyond which a #DIV0! error is returned in Excel 97 ?
 
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.
 

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

Back
Top