O'Reilly logo

Numbers for iPad: Visual QuickStart Guide by Chris Fehily

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

4. Formulas and Functions

In This Chapter

Formula Basics

Summarizing Data Quickly

Elements of Formulas

Entering Formulas

Determining the Order of Operations

Understanding Cell References

Using Cell References

Understanding Comparison Operators

Using Comparison Operators

Understanding Functions

Using Functions

Copying and Moving Formulas

Handling Errors

After you enter and organize your data values in tables, you can use formulas and functions to reduce reams of raw numbers to meaningful information. A formula performs a calculation and displays the result in the cell where you enter the formula, called a formula cell. Formulas can do things as simple as adding two numbers, but it’s by using functions in formulas that you bring to bear Numbers’ ...

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