Chapter 20. Using Formulas and Functions
In this chapter
Entering and Editing Formulas 594
Using Range Names and Labels in Formulas 601
Manipulating Data with Worksheet Functions 604
Finding the Right Function 608
Testing and Debugging Formulas 618
Secrets of the Office Masters: Using Goal Seek to Find Answers 625
Entering and Editing Formulas
Formulas add intelligence to a workbook. Using formulas, you can manipulate values (text, numbers, or dates), perform simple or complex calculations, and display alternative results based on logical tests. A formula can be as simple as a reference to another cell, or it can go on for hundreds of characters, with as many as seven functions nested within other functions. Regardless of ...
Get Special Edition Using 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.
