Chapter    9

Using Formulas and Functions in Your Worksheets

Many of your worksheets will likely need to perform calculations with your data. To perform calculations in Excel, you enter formulas and functions in the appropriate cells in the worksheets. This chapter will explain what formulas and functions are, and what the difference between them is, and then shows you how to use each. Along the way, you will learn how to refer to cells and ranges, meet the calculation operators that Excel supports, and discover how to use them. You will also learn about common problems that occur with formulas and ways to troubleshoot them.

Understanding the Difference Between Formulas and Functions

In Excel, you can perform calculations in two main ways, each ...

Get Pro Office for iPad: How to Be Productive with Office for iPad now with O’Reilly online learning.

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