Chapter 11: Working with Formulas and Functions
Understanding Formulas
You can use formulas, which you build using mathematical operators, values, and cell references, to perform all kinds of calculations on your Excel data. For example, you can add the contents of a column of monthly sales totals to determine the cumulative sales total.
If you are new to writing formulas, this section explains the basics of building your own formulas in Excel. You learn about the correct way to structure formulas in Excel, how to reference cell data in your formulas, which mathematical operators are available for your use, and more.
Formula Structure
Ordinarily, ...