Chapter 3: Formulas and Functions for Crunching Numbers
In This Chapter
Constructing a formula
Using cell ranges in formulas
Naming cell ranges
Referring to cells in other worksheets
Copying formulas to other columns and rows
Preventing errors in formulas
Using functions in formulas
Formulas are where it’s at as far as Excel is concerned. After you know how to construct formulas, and constructing them is pretty easy, you can put Excel to work. You can make the numbers speak to you. You can turn a bunch of unruly numbers into meaningful figures and statistics.
This chapter explains what a formula is, how to enter a formula, and how to enter a formula quickly. You also discover how to copy formulas from cell to cell and how to keep formula errors from creeping into your workbooks. Finally, ...