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

▶
Writing your own functions

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