Table → Formula

Use the Formula command to perform calculations on cells with numbers. For example, a column of numbers can be summed and the total presented at the bottom of the table. Place the insertion point in the cell that should contain the results of the formula and choose Table → Formula (Figure 10-24).

Figure 10-24. Constructing formulas that reference cells in a table

Word always suggests a formula based on the position of the active cell when the command is issued. This formula is rarely what is really needed. Just erase it to build your own. All formulas must start with an equals sign. After this, formulas are composed of three parts:

- Operators
Common mathematical operators such as +, -, *, and /.

- Functions
Special procedures provided by Word. Functions always appear outside parentheses. Examples of common functions are SUM, which is used to add specified values together, AVERAGE, which calculates the average of specified values, and MIN, which calculates the smallest of any specified values. Enter the name of a function directly into the Formula box or choose a function from the Paste Function list. Choosing from the list enters the value in the Formula box at the insertion point.

- Values
Simple numbers or the data in specific cells in a table. Values that are acted on by functions appear inside parentheses to the right of the function. For example, in the ...

Start Free Trial

No credit card required