Microsoft Office Tutorials and References

In Depth Information

**Entering Formulas**

2

•

RIGHT
ARROW

key to complete the

arithmetic operation

indicated by the

formula, to display

the result in the

worksheet, and to

select the cell to the

right (Figure 2 – 6). The

number of decimal

places shown in cell
F4

may be different, but

these values will be

adjusted later in this

chapter.

Press the

active cell

is G4 after

pressing RIGHT

ARROW key

value of formula

(65.25 × 20.5)

Figure 2–6

Arithmetic Operations

Table 2 – 2 describes multiplication and other valid Excel arithmetic operators.

Table 2 – 2 Summary of Arithmetic Operators

Arithmetic

Operator

Example

of Usage

Meaning

Meaning

–

Negation

– 78

Negative 78

%

Percentage

=23%

Multiplies 23 by 0.01

^

Exponentiation

=3 ^ 4

Raises 3 to the fourth power

*

Multiplication

=61.5 * C5

Multiplies the contents of cell C5 by 61.5

/

Division

=H3 / H11

Divides the contents of cell H3 by the contents of cell H11

+

Addition

=11 + 9

Adds 11 and 9

–

Subtraction

=22 – F15

Subtracts the contents of cell F15 from 22