Microsoft KB Archive/11575

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 &quot;75&quot; with &quot;EB&quot;. 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.