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 ...
Get Learn Excel 2011 for Mac now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
