Microsoft Office Tutorials and References
In Depth Information
Working with Tables
Chapter 5
Working with Columns and Tables
Word contains a number of predefined
calculations, called functions, that you can plug into your
formula fields. For example, if you simply want to
add adjacent cells, use the SUM function, such as
=SUM(ABOVE) or =SUM(LEFT). The ABOVE
function tells Word to add all the non-blank cells
directly above the answer cell. The LEFT function tells
Word to add all the non-blank cells directly to the
left of the answer cell. To use a function, choose
Table Tools>Layout>Data>Formula. You can either
accept the suggestion provided by Word, or click
the Paste Function drop-down menu and choose a
different function (see Figure 5-23).
Figure 5-22
Creating a calculation.
4. Optionally, choose an option from the
Number Format drop-down menu. This
option determines the appearance of your
answer such as whether to include a dollar
sign, a percent symbol, or two decimal points.
Tip
Word cannot use a function to total the
entire column or row if your column or
row contains blank cells or cells with text
instead of values.
5. Click OK. Word calculates the formula and
displays the results.
If you later make a change to any of the table cells
referenced in the formula, Word doesn’t
automatically update the formula answer. Right-click over
the current answer and choose Update Field.
View the Formula
If you want to see the actual formula instead
of the result, right-click over the answer and
choose Toggle Field Codes. To view the
answer again, repeat the action.
Figure 5-23
Using calculation functions.
Search JabSto ::




Custom Search