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

Get Numbers for iPad: Visual QuickStart Guide now with O’Reilly online learning.

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