KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

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

Article: Q183702
Product(s): Word 97 for Windows
Version(s): WINDOWS:97
Operating System(s): 
Keyword(s): kbfield word97
Last Modified: 14-NOV-2000

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Word 97 for Windows 
-------------------------------------------------------------------------------


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:

1. On the Table menu, click Insert Table.

2. In the Insert Table dialog box, set the Number of Columns to 3 and the Number
  of Rows to 5 and then click OK.

3. 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 |
          +----+----+----+

4. Set a bookmark on the sample table. To do this,

  a. Place the insertion point somewhere in the table. For example, move the
     insertion point into cell A1 of the table.

  b. On the Table menu, click Select Table.

  c. On the Insert Menu, click Bookmark.

  d. 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.

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:

1. Move the insertion point in your document outside of the table.

2. Press CTRL+F9 to enter type the field code braces ({}).

3. Inside the field code braces, type the following Formula field:

  { =SUM(Table1 B5) }

4. With the insertion point inside the field code braces, press F9 to update the
  field.

5. Press ALT+F9 to turn the field codes off. The result of the Formula field
  should show.

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:

1. Move the insertion point in your document outside of the table.

2. Press CTRL+F9 to type the field code braces ({}).

3. Inside the field code braces, type the following Formula field:

  { =SUM(Table1 B5)+ SUM(Table1 C5) }

4. With the insertion point inside the field code braces, press F9 to update the
  field.

5. Press ALT+F9 to turn the field codes off. The result of the Formula field
  should appear.

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

  Q185684 WD97: Wrong Calculation Result with Bookmarks in Table

Additional query words:

======================================================================
Keywords          : kbfield word97 
Technology        : kbWordSearch kbWord97 kbWord97Search kbZNotKeyword2
Version           : WINDOWS:97
Issue type        : kbinfo

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.