Building a Formula for Internal Rate of Return PSS ID Number: Q10248 Article last modified on 01-13-1989 PSS database name: D_MPlan

1.20

MS-DOS

Summary: The method of building a formula for Internal Rate of Return (IRR) described on Page 413 of the “Microsoft Multiplan” manual for Version 1.20 will not work correctly because it contains more characters than are allowed in a formula. Although the formula is mathematically correct, it cannot be used because it is too long. If this formula is entered, you will receive the following error messages:

"command too long" and "field has too many words"

Beginning with Version 2.00, Multiplan contains a formula for IRR, so there is no need to manually define the formula anymore.

Copyright Microsoft Corporation 1989.