On Fri, 11 Nov 2005 11:02:05 -0800, "Mac6668"
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