Chapter 19. Using Formulas and Functions
In this chapter
Entering and Editing Formulas 594
Using Range Names and Labels in Formulas 602
Manipulating Data with Worksheet Functions 607
Putting Worksheet Functions to Use 611
Using Goal Seek to Find Values 622
Extra Credit: Nesting Functions Within Functions 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.
With the help of formulas, you can perform any of the following common tasks:
• Manage home finances by tracking expenses
• Simplify coursework in advanced math ...
Get Special Edition Using Microsoft® Office 2003 Student-Teacher Edition 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.