User Guide

Formula Tools
You add a formula to a table cell when you want to display a value in the cell that’s
derived using a calculation. Numbers has several tools for working with formulas in
table cells:
The  Formula Editor lets you create and modify formulas. Open the Formula Editor by
selecting a table cell and typing the equal sign (=). You can also open it by choosing
Formula Editor from the Function pop-up menu in the toolbar.
Cancel button
Discard changes.
Accept button
Save changes.
Text field
View or edit a formula.
Formula Editor
Move by grabbing
here and dragging.
Learn more about this editor in “Adding and Editing Formulas Using the Formula
Editor” on page 11 9 .
The  formula bar, always visible below the format bar, can also be used to create and
modify a formula in a selected table cell.
Open the
Function Browser.
Cancel button
Discard changes.
Accept button
Save changes.
Change the formula
viewing size.
Text field
View or edit a formula.
Instructions for adding and editing formulas using this tool are in “Adding and
Editing Formulas Using the Formula Bar” on page 12 0 .
20 Chapter 1 Numbers Tools and Techniques