O'Reilly logo

Word 2000 in a Nutshell by Walter Glenn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

Table Formula

Synopsis

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

Constructing formulas that reference cells in a table

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required