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!
Master Operator Precedence
One of the most important factors in writing formulas is getting 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 ...