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

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:

On the Table menu, click Insert Table.
On the Insert Table dialog box, set the Number Of Columns to 3 and the Number Of Rows to 5, and click OK.
In cell B5, enter the number 8, in cell C5, enter the number 10.
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).
On the Insert menu, click Bookmark.
Type a name for the bookmark, such as Table1 and click Add.
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