Microsoft KB Archive/183702

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

Article ID: 183702

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q183702





SUMMARY
In Microsoft Word 97 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, click the Index tab in Microsoft Word Help, type the following text

fields, field

and then double-click the selected text to go to the "Field codes: = (Formula) field" topic. 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,  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 CTRL+F9 to enter 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 ALT+F9 to turn the field codes off. The result of the Formula field should show.</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 CTRL+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 ALT+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 WD97: Wrong Calculation Result with Bookmarks in Table

Keywords: kbfield kbinfo KB183702

-

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

© Microsoft Corporation. All rights reserved.