Microsoft KB Archive/10248

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:13, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q10248 to Microsoft KB Archive/10248 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.