Calculating a Value in a Table

graphics/microsoftoffice24.gif

Sometimes the simple equations proposed by Word do not adequately cover what you are trying to calculate in the table. When that is the case, you need to create a custom equation to do the work. The Formula dialog box give you a choice of 18 paste functions to help you create your formula. Should you need help, you can activate Help to see examples of how to use each paste function, or for more complex formulas, try Microsoft's Online Community to look for advice from other users.

Calculate a Value

graphics/one_icon.jpg

Click the cell in which you want the result to appear.

graphics/two_icon.jpg

Click the Table menu ' and then click Formula. If Word proposes a formula that you do not want to use, delete it from the Formula box.

graphics/three_icon.jpg

Click the Paste Function list arrow, and then select a function.

graphics/four_icon.jpg

To reference the contents of a table cell, type the cell references in the parentheses in the formula. For instance, to average the values in cells a1 through a4, the formula would read =Average(a1,a4). If you are doing the average of a row in the last column of the row, simplify this to =Average(left).

graphics/five_icon.jpg

In the Number Format box, enter a format for the numbers. For example, to display the numbers as a decimal percentage, click 0.00%. For now, enter 0 to display the average as the nearest whole number. To display a true average, enter 0.00 in the Number Format box.

graphics/six_icon.jpg

Click OK.

graphics/06inf29.jpg

graphics/06inf30.jpg

graphics/06inf31.jpg



Show Me. Microsoft Office Word 2003. See it Done, Do It Yourself
Show Me. Microsoft Office Word 2003. See it Done, Do It Yourself
ISBN: N/A
EAN: N/A
Year: 2002
Pages: 310

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net