O'Reilly logo

Pro Office for iPad: How to Be Productive with Office for iPad by Guy Hart-Davis

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

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