Languages

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
Helpful?
Yes
No
Not helpful Somewhat helpful Helpful Very helpful Solved my problem
Print this page
  • Last Modified: Jan 13, 2012
  • Article: HT3354
  • Views:

    82565
  • Rating:
    • 52.0

    (888 Responses)

Additional Product Support Information

Start a Discussion
in Apple Support Communities
See all questions on this article See all questions I have asked