Understanding the Components of Formulas
When you need to perform a custom calculation in a cell, use a formula rather than a function. All you need to do is type in a simple formula using the appropriate calculation operators, such as + signs for addition and – signs for subtraction. In this section, you'll meet the calculation operators, try using them in a worksheet, and learn the order in which Excel applies them—and how to change that order.
Meeting Excel's Calculation Operators
To perform calculations in Excel, you need to know the operators for the different operations—addition, division, comparison, and so on. Table 5–1 explains the full set of calculation operators you can use in your formulas in Excel.
Table 5–1 Calculation Operators ...
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.
