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




Custom Search