View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default IRR showed #NUM!

On Sun, 14 Dec 2008 10:22:16 -0500, Dana DeLouis
wrote:

If anyone is interested. This problem should converge to a solution
quickly even if we (or Excel) are not accurate in our derivative. I
believe there is a logic bug somewhere in Excel's IRR algorithm.
However, the nature of this particular problem does allow us to have a
more exact derivative. Here is one method where we can be more exact...

=MyIRR(A1:A10)


Thanks, Dana
--ron