M
Mac6668
would appreciate it if someone can explain why the IRR function calculation
computes erratically in 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!"
computes erratically in 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!"