Microsoft KB Archive/46487
Mac Works:Rounding Errors on Macs with Built-In Math Coprocessor
PSS ID Number: Q46487 Article last modified on 10-22-1998
2.00 3.00 4.00
|The information in this article applies to:|
|- Microsoft Works for the Macintosh, versions 2.0, 3.0 and 4.0|
This article discusses error messages that can occur with Macintosh computers with built-in math coprocessors.
Works 2.0 and 3.0
If you are using version 2.0 or 3.0 of Works with a Macintosh that has a built-in math coprocessor, the Spreadsheet and Database modules of Works will round numbers down that end in “5” instead of rounding them up.
For example, if the number 6.465 is displayed with two decimal places, it reads 6.46 instead of 6.47. This error occurs when formatting is applied to give a value a fixed number of decimal places, and when the Round function is used to round to a specified number of decimal places.
These rounding operations work correctly on machines without a math coprocessor. To work around this problem, add a very small number to the value, such as .000000001, to make it round up.
Cells formatted to include a given number of decimal places will display correctly in Works for the Macintosh version 4.0. However, it is still necessary to use the workaround listed above for the Round function on machines with built-in math coprocessors.
Machines with built-in math coprocessors include the Macintosh II, IIx, IIcx, and SE/30. Math coprocessor boards also can be added to the standard SE. A Macintosh SE has been tested with two such boards; the rounding problems did not occur on this machine.
KBCategory: kbother KBSubcategory: macworkskb
Additional reference words: 2.00 3.00 mwksss mwksdb mwksprb plus
Version : 2.00 3.00 4.00 Platform : MACINTOSH ============================================================================= Copyright Microsoft Corporation 1998.