Microsoft KB Archive/40191

The Maximum Entries for SUM, STDEV, and AVERAGE Functions Is 5 PSS ID Number: Q40191 Article last modified on 01-12-1989 PSS database name: D_MPlan

3.x

MS-DOS

Summary:

In Multiplan Versions 3.x, the message “Not a valid formula” occurs if the SUM, STDEV, or AVERAGE functions contain more than five disjointed ranges in their lists. For example, you will get the error message if you try to enter the following formula:

SUM(RC[-1],RC[-2][-3],RC[+9][-5],RC[+2][-4],RC[1][-9],RC[-6][7])

However, the Multiplan program will accept the formula if one of the items in the list is removed, as in the following example:

SUM(RC[-1],RC[-2][-3],RC[+2][-4],RC[1][-9],RC[-6][7])

In Multiplan Versions 3.x, these formulas can have a maximum of five disjointed entries in the list.

Copyright Microsoft Corporation 1989.