O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Creating Complex Formulas

As you saw in the previous section, you can quickly create straightforward formulas with a single operator. But often you'll need to create formulas that use multiple operators, as you also did in the previous section. When you do, you must understand the order in which Excel evaluates the operators so that you can get the calculation correct. You also need to know how to tell Excel to evaluate the operators in a different order. And you may want to break a complex formula into multiple steps so you can see exactly what you're doing.

Understanding the Order in Which Excel Evaluates Operators

In the previous example, you entered the formula =B1-(B2+B4) in cell B5. The parentheses are necessary because the calculation ...

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