Chapter 15. Introducing Formulas and Functions

In This Chapter

Understanding formula basics

Entering formulas and functions into your worksheets

Understanding how to use references in formulas

Correcting common formula errors

Tips for working with formulas

Formulas are what make a spreadsheet program so powerful. If it weren’t for formulas, a spreadsheet would simply be a glorified word-processing document that has great support for tabular information. You use formulas in your Excel worksheets to calculate results from the data stored in the worksheet. When data changes, those formulas calculate updated results with no extra effort on your part. This chapter introduces formulas and functions and helps you get up to speed with this important element.

Get Office 2007 Bible 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.