On Fri, 11 Nov 2005 11:02:05 -0800, "Mac6668"
<Mac6668@discussions.microsoft.com> wrote:

>I would appreciate it if someone can explain why the IRR function calculation
>computes erratically on a MS Excel 2003 SP1 spreadsheet.
>
>If you reduce the numerical value in cell C4 to 77.9 % of its current value,
>the worksheet will calculate. At 78% of its value it returns "#NUM! ; and
>at 78.2% it calculates; and at 78.3% it returns "#DIV/0!"


Not much detail here.

On a new worksheet, C4 = 0 and IRR(C4) --> #NUM!

78% of C4 is still zero.

Perhaps if you post a bit more detail, someone might be able to give you better
insight into what is going on.


--ron