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
 
Search JabSto ::




Custom Search