Calculation Errors in Multiplan 2.01
PSS ID Number: Q11575
Article last modified on 04-18-1988
PSS database name: D_MPlan

2.01

MS-DOS


Problem:
   When the following steps are completed, a calculation error occurs
in Multiplan Version 2.01: 

   1. Enter value 2.8 in R1C1.
   2. Enter value 1.8 in R2C1.
   3. Enter formula R1C1-R2C1 in R3C1.

   The value 0.0 is displayed in R3C1 rather than the value 1. This error
did not occur in Version 2.00. 

Response:
   This is an error in the emulation math pack, and occurs only in the
GEN or EXP formats for some formulas with results just below 1.0 or
just above -1.0. 
   This problem can be patched using DEBUG as follows:

    1. Copy MP.COM MP.BAK to make a backup copy.
    2. Debug MP.COM.
    3. E 4BC2.  
    4. Replace the byte "75" with "EB".
    5. W.
    6. Q.

   Test the fixed MP.COM to see if it works properly and corrects the
problem. When recalculation errors no longer occur, put your backup
MP.BAK in archive or erase it. If there is some problem with the
patched version, repeat the above steps by copying MP.BAK MP.COM. 

Copyright Microsoft Corporation 1988.