Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/10248

From BetaArchive Wiki

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



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.