Excel: IRR and RATE Give Different Results in Version 3.00

• Microsoft Excel for Windows, versions 3.0, 4.0
• Microsoft Excel for the Macintosh, versions 3.0, 4.0

SUMMARY

In Microsoft Excel version 3.0 or 4.0, the IRR and RATE functions have been enhanced to increase the precision of the answer. Therefore, it is possible for IRR and RATE to return a different values than they do in Microsoft Excel version 2.2 or earlier.

MORE INFORMATION

Excel 3.0 increases the precision of IRR and RATE by increasing the number of iterations before the solution is returned.

Additional query words:

Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 21, 1999