Numbers '09: 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.
- The formula bar, always visible below the format bar, can also be used to create and modify a formula in a selected table cell.
- Using the Function Browser is the fastest way to add a function. A function is a predefined formula that has a name (such as SUM and AVERAGE).
- To open the Function Browser, choose Show Function Browser from the Function pop-up menu in the toolbar.
Last Modified: Jan 13, 2012