Microsoft KB Archive/60119

{| = Excel Err Msg: #DIV/0! with IRR or MIRR Instead of #NUM! =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q60119

SUMMARY
In Microsoft Excel, the #DIV/0! error message can be returned by a cell when calculating IRR or MIRR. This occurs when the IRR or MIRR can't be calculated within 20 iterations and no math coprocessor is present on the machine. The presence of a math coprocessor causes a #NUM! error message to be returned instead.

For more information on the IRR and MIRR functions, see pages 48 and 62, respectively, in the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual, or query on the following words:

IRR and MIRR
 * }