Microsoft Office Tutorials and References
In Depth Information
CHAPTER 1 Functions Overview
Table 1.1
Argument Types
Argument
Example
Numbers
1,2,3
Text
“Januar y”
Logical Values
(True or False)
Cell References
B7 or B7:B20
Operators
Operators are really broken into four categories: arithmetic operators, comparison operators,
text operators, and reference operators. An operator simply tells Excel what kind of
calculation you want to perform. For example, if I wanted to divide 7 by 3, the operator is the front
slash key and tells Excel to divide. In essence, it’s a language used to talk to Excel and to tell
it what you want to do. You could use voice recognition to tell Excel to divide or you could
learn the keystroke language as shown in Table 1.2.
Table 1.2
Keystroke Operators
Arithmetic
Explanation
Example
Addition
+
2+3
Subtraction

51
Negation
7
Multiplication
*
7*3
Division
/
7/2
Percent
%
90%
Exponentiation
^
7^2
Comparison
Explanation
Example
Equal to
=
B1=D1
Greater than
>
B1>D1
Less than
<
B1<D1
Greater than or equal to
>=
B1>=D1
Less than or equal to
<=
B1<=D1
Not equal to
<>
B1<>D1