Microsoft KB Archive/185679

= WD98: DocErr: "Field Codes: =(Formula) Field" Help Topic Wrong =

Article ID: 185679

Article Last Modified on 10/31/2006

-

APPLIES TO


 * Microsoft Word 98 for Macintosh

-



This article was previously published under Q185679





SUMMARY
In Microsoft Word 98 Macintosh Edition Help, the following example in the "Field Codes: =(Formula) field" help topic is incorrect.   Field                Result -  { =(Table3 C3) }     The contents of the cell in the third column of the third row of the table marked by the bookmark "Table3." The correct formula should be as follows: { =SUM(Table3 C3) } NOTE: The formula must contain a function. For example, SUM, PRODUCT, and AVERAGE are functions.

For more information about "Field codes: =(Formula) field", click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in MS Word Help, type the following text

field

and then click Show Topics. Select the "Field codes: =(Formula) field" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.



MORE INFORMATION
When you need to reference or calculate table cells in your document outside of the table, you can use the Formula field. The following are examples how to use the Formula field correctly.

To set up a sample table, follow these steps:

 On the Table menu, click Insert Table. In the Insert Table dialog box, set the Number Of Columns to 3 and the Number Of Rows to 5, and then click OK.  In cell B5, type the number 8, and in cell C5, type the number 10.

For example, our sample table looks like the following:         Row      COLUMN ---   ---

A   B    C

++++         1   |    |    |    |              ++++          2   |    |    |    |              ++++          3   |    |    |    |              ++++          4   |    |    |    |              ++++          5   |    |  8 | 10 |              ++++                     Set a bookmark on the sample table. To do this, follow these steps:  Place the insertion point somewhere in the table. For example, move the insertion point into cell A1 of the table.</li> On the Table menu, click Select Table.</li> On the Insert Menu, click Bookmark.</li> In the Bookmark name box, type a name for the table, and then click Add.

NOTE: In our example, Table1 is used as the bookmark name for the sample table.</li></ol> </li></ol>

Example 1: To Reference a Cell Outside the Table
To reference a table cell outside of the table in your document, use the following steps:

<ol> Move the insertion point in your document outside of the table.</li> Press COMMAND+F9 to type the field code braces ({}).</li>  Inside the field code braces, type the following Formula field: { =SUM(Table1 B5) } </li> With the insertion point inside the field code braces, press F9 to update the field.</li> Press OPTION+F9 to turn the field codes off. The result of the Formula field should appear.</li></ol>

Example 2: To Add Two Cells Outside of the Table
To add two cells from the same table, such as in our example, cell B5 and C5, use the following steps:

<ol> Move the insertion point in your document outside of the table.</li> Press COMMAND+F9 to type the field code braces ({}).</li>  Inside the field code braces, type the following Formula field: { =SUM(Table1 B5)+ SUM(Table1 C5) } </li> With the insertion point inside the field code braces, press F9 to update the field.</li> Press OPTION+F9 to turn the field codes off. The result of the Formula field should appear.</li></ol>

For additional information, please see the following article in the Microsoft Knowledge Base:

185684 WD98: Wrong Calculation Result with Bookmarks in Table

Keywords: kbhowto KB185679

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.