Microsoft Office Tutorials and References
In Depth Information
Working with Tables
Table 5-2
Mathematical Operators Used in Word
Name
Operator Example
Result
+
{=6+3}
9
Subtraction
{=6-3}
3
Multiplication
*
{=6*3}
18
Division
/
{=6/3}
2
Figure 5-21
The Formula dialog box.
Percentage
%
{=6%}
.06
Exponentiation
^
{=6^3}
216
2. Sometimes Word can detect the formula you
want and automatically creates instructions.
In the previous figure, Word assumes you
want to add together (SUM) the cells above
the current cell. Maybe you do, but to
illustrate a formula, let’s manually enter it.
Highlight the existing text in the Formula
text box and type an equals sign (=).
When creating a calculation, the power comes in
to play in that you typically don’t use the actual
values; instead, you create a reference to them.
Suppose cell B2 has a value of 6 and cell B3 has a
value of 3. Now, suppose you want, in cell B4, to
multiply those two values. In cell B4, you won’t
enter =6*3; instead, you’ll enter =B2*B3. The
advantage is that if you later change the value in
cell B2 from 6 to 8, you won’t have to retype the
calculation—you’ll simply tell Word to recalculate
it. Look at how this is all accomplished:
3. Type the rest of your formula such as you see
in Figure 5-22. In this example, you want to
multiply cells B3 and C3, which will give the
total amount.
1.
First you must realize that calculations in
Word tables are generated from formula
fields. Click the cell in which you want a
formula field and choose Table Tools>Layout>
Data>Formula. You see the Formula dialog
box shown in Figure 5-21.
Search JabSto ::

Custom Search