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

Troubleshooting Formulas 618

Using Goal Seek to Find Values 622

Troubleshooting 624

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.