Microsoft Office Tutorials and References

In Depth Information

**Chapter 3: Formulas and Functions for Crunching Numbers**

Operators in formulas

Addition, subtraction, and division aren’t the only operators you can use in

formulas. Table 3-1 explains the arithmetic operators you can use and the

key you press to enter each operator. In the table, operators are listed in

the order of precedence (see the “The order of preference” sidebar for an

explanation of precedence).

Table 3-1

Arithmetic Operators for Use in Formulas

Precedence

Operator

Example Formula

Returns

1

% (Percent)

=50%

50 percent, or 0.5

2

^ (Exponentiation)

50 to the second power,

or 2500

=50^2,

3

* (Multiplication)

=E2*4

The value in cell E2

multiplied by 4

3

/ (Division)

=E2/3

The value in cell E2

divided by 3

4

+ (Addition)

=F1+F2+F3,

The sum of the values in

those cells

4

– (Subtraction)

=G5–8,

The value in cell G5 minus 8

Book III

Chapter 3

5

& (Concatenation)

="Part No.

"&D4

The text
Part No.
and the

value in cell D4

6

= (Equal to)

=C5=4,

If the value in cell C5 is

equal to 4, returns
TRUE
;

returns
FALSE
otherwise

6

<> (Not equal to)

=F3<>9

If the value in cell F3 is
not

equal to 9, returns
TRUE
;

returns
FALSE
otherwise

6

< (Less than)

=B9<E11

If the value in cell B9 is

less than the value in

cell E11; returns
TRUE
;

returns
FALSE
otherwise

6

<= (Less than or

equal to)

=A4<=9

If the value in cell A4 is

less than or equal to 9,

returns
TRUE
; returns

FALSE
otherwise

6

> (Greater than)

=E8>14

If the value in cell E8 is

greater than 14, returns

TRUE
; returns
FALSE

otherwise

6

>= (Greater than

or equal to)

If the value in cell C3 is

greater than or equal

to the value in cell D3;

returns
TRUE
; returns

FALSE
otherwise

=C3>=D3