O'Reilly logo

Special Edition Using Microsoft Office 2007 by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Troubleshooting 624

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required