Microsoft KB Archive/30567

= XL: IRR Returns #DIV/0! Instead of #NUM! If No IRR Exists =

Article ID: 30567

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q30567



SYMPTOMS
If you use the IRR function on a set of data that does not have an IRR (internal rate of return), the function sometimes returns a #DIV/0 error when it should return a #NUM! error.

NOTE: IRR is calculated by setting the NPV formula equal to 0 (zero) and solving for the interest rate.



CAUSE
In this formula, the future cash flows are divided by a discount factor. If the discount factor becomes too small, Excel may consider it a 0 (zero). If Excel considers this number a zero, it produces a #DIV/0 error.

Additional query words: XL2002 XL2000 XL97

Keywords: kbprb KB30567

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.