Microsoft KB Archive/23600

Mac Works: IRR and MIRR Functions Return #NUM or Error

PSS ID Number: Q23600 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0 4.0

MACINTOSH

=
=========================================================

= SUMMARY =

In Microsoft Works, the IRR and MIRR functions must be supplied with an array of values and a guess value from which the result can be calculated within 20 iterations. The function may return #NUM or Error instead of a value. Two reasons for this are as follows:


 * 1) The guess is not accurate enough for the function to converge within the required 20 iterations.
 * 2) The array contains values that cannot converge to a correct value.

= MORE INFORMATION =

For the functions to operate properly, the first value in the array must be a negative number. This first value is the initial investment. If it is positive, the internal rate of return will be infinite.

If the guess value is not accurate enough, it is necessary to select various higher or lower guesses until the function can converge.

KBCategory: kbusage kberrmsg KBSubcategory: macworkskb

= Additional reference words: 1.00 1.10 2.0 3.0 4.0 mswksss wrong value =

Keywords : kberrmsg Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1998.