![]() |
Math Rounding Numbers Incorrectly |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Symptoms: Math and Table Math is rounding numbers to the hundredths incorrectly. For example, dividing 86 by 103 and rounding to 2 decimal places gives .84, instead of .83. Solutions: This is a limitation of WP and should be written up as an Enhancement. WordPerfect, when calculating, automatically rounds to 4 decimal places which can throw things off. For example: Dividing 86 by 103 results in .8349514. However, when calculating, WordPerfect rounds to 4 decimal places which is .8350 in this example. Later, when rounded to 2 decimal places it rounds to .84. The manual states that "constants in math formulas can only have up to 4 decimal places. For example, in the formula "A*.00349" WP only calculates it as A*.0034. In this particular case, you could change the formula to A*.0349/10 and it would work fine. Tables use the 4 digits to the right of the decimal rule, the same as the Math feature." So, as the manual example shows, you can move the decimal to the right one place and divide by 10 for a workaround if the number of decimal places is five. If it was six, you could move the decimal two places to the right and divide by 100, etc. This feature is working as designed. This problem will not be addressed in WP 5.1 because of design limitations. However, WP may address this problem in a future version. |
Answer:
Details:
Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER. |