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