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 wild cards. 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 wild cards like < and ^ used with the IF function.

Add conditions and wild cards

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

Functions that accept conditions and wild cards 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.