Microsoft KB Archive/59234

Multiplan: Incorrect Value from Numeric Intersection PSS ID Number: Q59234 Article last modified on 03-28-1990 PSS database name: D_MPlan

4.00 4.01

MS-DOS

Summary:

In Multiplan Versions 4.00 and 4.01, the intersection operator may result in a #VALUE! error message or apparent errors in other cells of the worksheet. A cell referencing another cell containing an intersection can easily refer to an unintended range. When attempting to copy a single-cell numeric range, place each intersection within a SUM function. This converts the range to a value.

For instance, when attempting to obtain a value stored in Row 2 of the current column, select the Value command and enter the formula “SUM(R2 C)”. Entering “R2 C” may result in #VALUE! error messages in other cells.

Multiplan Version 4.20 has been improved to allow a more liberal interpretation of copied ranges similar to versions prior to 4.00.

Copyright Microsoft Corporation 1990.