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

Start your free trial