Microsoft KB Archive/183703

= WD98: Help Topic Error For "Field Codes: = (Formula) Field" =

Article ID: 183703

Article Last Modified on 10/4/2002

-

APPLIES TO


 * Microsoft Word 98 for Macintosh

-



This article was previously published under Q183703





SUMMARY
In Microsoft Word 98 Macintosh Edition, the following example in the "Field Codes: = (Formula) field" in Help topic is incorrect.   {=(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 is as follows:   {=sum(Table3 [C3])} This formula must contain a function and the cell reference needs to be in square brackets ([]).



MORE INFORMATION
To find the "Field codes: = (Formula) field" help topic of, click the Office Assistant, type field codes, click Search, and then click to view "Field codes: (Formula) field." (You may have to click See more to see this entry.)

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

179216 OFF98: How to Use the Microsoft Office Installer Program

Example of Correct Use of Formula
Here is an example of how to use this formula correctly.

Suppose you want to refer to individual cells by applying a bookmark anywhere in the table. This method is most efficient when you need to use several cells from the table. To do this, follow these steps:
 * 1) On the Table menu, click Insert Table.
 * 2) On the Insert Table dialog box, set the Number Of Columns to 3 and the Number Of Rows to 5, and click OK.
 * 3) In cell B5, enter the number 8, in cell C5, enter the number 10.
 * 4) Place the insertion point somewhere in the table where a bookmark is unlikely to ever be deleted. For example, place the insertion point in cell A1 (top, left cell).
 * 5) On the Insert menu, click Bookmark.
 * 6) Type a name for the bookmark, such as Table1 and click Add.
 * 7) Move the insertion point to the place where you want the formula.

To reference cell B5 at the insertion point, follow these steps:  Press COMMAND+F9 to enter field codes ({}).  Inside the field codes, type the following:      {=sum(Table1[b5])}  Press F9 to update the field.

To add two cells from the same table, such as in our example, cell B5 and C5, use the following formula inside the field codes ({}):      {=sum(Table1[B5])+sum(Table1[C5])} For additional information, please see the following article in the Microsoft Knowledge Base:

113980 WD: Wrong Calculation Result with Bookmarks in Table

Additional query words: macword98

Keywords: kbfield KB183703

-

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

© Microsoft Corporation. All rights reserved.