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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.