Chapter 11. Working with Formulas and Functions
Understanding Formulas
You can use formulas to perform all kinds of calculations on your Excel data. You can build formulas using mathematical operators, values, and cell references. 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 task explains all of the basics required to build your own formulas in Excel.
Formula Structure
Ordinarily, when you write a mathematical formula, you write the values and the operators, followed by an equal sign, such as 2+2=. In Excel, formula structure works a bit differently. All Excel formulas begin with an equal sign (=), such as =2+2. The equal sign immediately ...
Get Teach Yourself VISUALLY™ Microsoft® Office 2007 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.
