Chapter 20. Understanding Formulas
In this chapter
Getting the Most from This Chapter 386
Entering Your First Formula 388
Three Methods of Entering Formulas 395
Entering the Same Formula in Many Cells 398
Copying a Formula by Using the Table Tool 402
Excel’s forte is performing calculations. When you use Excel, you typically use a combination of cells with numbers and cells with formulas. After you design a spreadsheet to calculate something, you can easily change the numbers used in the assumption cells and then watch Excel instantly calculate new results.
Getting the Most from This Chapter
Don’t skip this entire chapter, because one particular trick in this chapter will save you daily frustration.
I regularly entertain ...
Get Special Edition Using Microsoft® Office Excel® 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.
