O'Reilly logo

Excel Formulas & Functions For Dummies, 5th Edition by Ken Bluttman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18

Ten Tips for Working with Formulas

IN THIS CHAPTER

Bullet Making sure the order of operators is correct

Bullet Viewing and fixing formulas

Bullet Referencing cells and using names

Bullet Setting the calculation mode

Bullet Using conditional formatting and data validation

Bullet 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required