A table showing a formula to calculate mortgage rate.

Insert a formula

Use formulas and functions in tables in the iWork apps—Numbers, Keynote, and Pages. Formulas can be as easy as typing an equation like you might in a calculator, or you can add complexity with cell references, functions, and wildcards. To get started, just type the equal sign in an empty table cell to open the Formula Editor.

Formulas overview

A table showing the functions IFERROR and PMT being used in a formula.

Use functions

There are hundreds of functions that you can use in your formulas to perform calculations, retrieve information, or manipulate data. Functions can help you easily create budgets, track work hours, maintain a grade book, and more.

Functions overview

The Formula Editor, showing conditions and wildcards like < and ^ used with the IF function.

Add conditions and wildcards

With some functions, you can use conditions to determine which cells to evaluate and wildcards to match characters in an expression.

Functions that accept conditions and wildcards as arguments

The Functions Browser showing information for the function IFERROR.

Learn through examples

In Numbers, Pages, or Keynote on your Mac or on iCloud.com, or in Numbers on iPhone or iPad, you have access to the in-app Functions Browser, which provides a list of functions, as well as basic examples and information about how to use each function. You can also see a list of functions by category in this help, as well as more in-depth examples for some functions.

List of functions by category

To explore the Formulas and Functions Help, click Table of Contents at the top of the page, or enter a word or phrase in the search field.

For specific instructions on how to accomplish tasks in Numbers, Pages, or Keynote, see the user guide for that app.

Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.