Microsoft Office Tutorials and References

In Depth Information

**Chapter 9: Playing with Formulas**

Table 9-1

Common Mathematical Operators

Used to Create Formulas

Operator

What It Does

Example

Result

+

Addition

=5+3.4

8.4

–

Subtraction

=54.2-2.1

52.1

*

Multiplication

=1.2*4

4.8

/

Division

=25/5

5

%

Percentage

=42%

0.42

^

Exponentiation

=4^3

64

=

Equal

=6=7

False

>

Greater than

=7>2

True

<

Less than

=9<8

False

>=

Greater than or equal to

=45>=3

True

<=

Less than or equal to

=40<=2

False

<>

Not equal to

=5<>7

True

&

Text concatenation

=”Bo the “&

“Cat”

Bo the Cat

A simple formula uses a single mathematical operator and two cell references

such as:

=A4+C7

This formula consists of three parts:

✓
The = sign:
This identifies your formula. If you type just
A4+C7
into a

cell, Excel treats it as ordinary text.

✓

Two cell references:
In this example, A4 and C7.

✓
The addition (+) mathematical operator.

To type a formula in a cell, follow these steps:

1. Click in the cell where you want to store the formula.

You can also select a cell by pressing the arrow keys.

Excel highlights your selected cell.