Microsoft Office Tutorials and References
In Depth Information
CHAPTER 1 Functions Overview
Table 1.2
Keystroke Operators
Text
Explanation
Example
&
“Scott” & “Blattner”
produce “ScottBlattner”
Reference
Explanation
Example
One reference between all cells
:
B3:B20
Separates arguments in a function
,
(B3,B20)
Operator Order
When creating complicated formulas or formulas that include more than one operator, there
is a specific order to use. The order is listed in Table 1.3. Meaning, if I were to create a
formula that contained % and the operator + , the % would come first.
Table 1.3
Excel’s Operator Order
Operator Order
Example
1
% Percent
2
^ Exponentiation
3
*/ Multiplication before Division
4
+ – Addition and then Subtraction
5
6
> , >= , < , <= , = , <> Comparisons
Custom Functions
You can create custom functions in Excel, however, be sure Excel has not already addressed
a function that will work for your specific needs. Note the following custom function example.
If I was in the construction industry, and had a specific calculation that included a formula
with rates that were specific to my company and equipment, and a profit rate that was also
specific to my company, I would want to create the custom function =TRUCKRATE(xxx) . Now,
every time that I estimate an amount of material to be moved and it includes the use of a Cat
777 truck, it would calculate the amount of material based on the 777 truck base rate plus