Microsoft Office Tutorials and References
In Depth Information
Chapter 18: Ten Tips for Working with Formulas
Chapter 18
Ten Tips for Working
with Formulas
In This Chapter
Making sure the order of operators is correct
Viewing and fixing formulas
Referencing cells and using names
Setting the calculation mode
Using conditional formatting and data validation
Several elements can help you be as productive as possible when writing
and correcting formulas. You can view all your formulas at once and
correct errors one by one. You can use add-in wizards to help write functions.
You can even create functions all on your own!
Operator Precedence
One of the most important factors when writing formulas is to get the
operators correct, and I do not mean telephone company operators. This has to do
with mathematical operators — you know, little details such as plus signs, and
multiplication signs, and where the parentheses go. Operator precedence
the order in which operations are performed — can make a big difference in
the result. You have an easy way to keep your operator precedence in order.
All you have to remember is “Please excuse my dear Aunt Sally.”
No, I have not lost my mind! This phrase is a mnemonic for the following:
1. Parentheses
2. Exponents
Search JabSto ::

Custom Search