Publishers of technology books, eBooks, and videos for creative people

Home > Articles

  • Print
  • + Share This
This chapter is from the book

Using Functions

A function can be one of several elements in a formula, or it can be the only element in a formula. When you build a formula, you don’t type the function names yourself—you use the function browser to insert them. The function browser lets you flick through Numbers’ entire library of functions. When you find the function you want, Numbers inserts it into your formula, including gray-oval argument placeholders. Placeholders for optional arguments are a lighter gray than those of required arguments.

To insert a function in a formula:

  1. In the formula bar, position the insertion point where you want the function to appear or, to replace an existing function, tap its name to select it.
  2. Tap the functions key on the keyboard and do one of the following:
  3. In the formula bar, tap each argument placeholder and do one of the following circle-d.jpg and circle-e.jpg:
  • + Share This
  • 🔖 Save To Your Account