Microsoft Office Tutorials and References

In Depth Information

**Working with Tables**

Table 5-2

Mathematical Operators Used in Word

Name

Operator Example

Result

Addition

+

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