WD2001: Formula Calculation Using the 0.00% Format Produces Incorrect Results
Article ID: 206123
Article Last Modified on 1/23/2007
APPLIES TO
- Microsoft Word 2001 for Mac
This article was previously published under Q206123
SYMPTOMS
When you enter a calculation using the 0.00% format, you may receive incorrect results. For example, the formula {=4/2 \# "0.00%"} gives a result of 2.00% rather than the expected 200%.
WORKAROUND
To work around this issue, avoid using percent (%) formats in your formula. Instead, use the basic number (0) format combined with a simple calculation to determine percentages, and then add the percent symbol after your formula.
For example, to enter a formula to produce the percent difference between x and y, use the calculation (x/y)*100 in your formula.
To do this, follow these steps:
- Start Microsoft Word 2001.
- On the Table menu, click Formula.
- In the Formula box, type =(4/2)*100.
- In the Number Format list, click 0, and then click OK.
- Press the percent (%) key.
STATUS
Microsoft has confirmed that this is a problem in Microsoft Word 2001 Macintosh Edition.
MORE INFORMATION
Press OPTION+F9 to toggle (show or hide) the field codes.
Press COMMAND+F9 to add an empty field.
Additional query words: OFF98 mac macword WD2001KB
Keywords: kbbug kbpending KB206123