Use the formula keyboard in Numbers on iPhone

You can use the formula keyboard to add mathematical calculations to your spreadsheet, and to choose functions from the Functions Browser.

To open the formula keyboard, tap a cell, tap the Show Keyboard button at the bottom of the screen, then tap the Formula Keyboard button above the keyboard on the left.

The formula keyboard, with the Formula Editor at the top and the operators used in formulas below it. The Functions button for opening the Functions Browser is to the left of the operators, and the Action menu button is to the right.

To enter data with the formula keyboard, do any of the following:

  • Add text: Tap the letter keys.

  • Add a function: If you know which function you want to enter, start typing it, then tap one of the suggestions that appears.

    If you’re not sure which function you need, tap the Functions button to open the Functions Browser, tap Categories at the bottom of the Functions Browser, then tap a function category. Tap a function to insert it in the Formula Editor (swipe up and down to see the available functions). To learn more about any function, tap the Info button next to it. (The first time you tap the Info button, it might take a few seconds to display the information.)

  • Add a number or symbol: Tap symbols in the top row of the keyboard, or to enter numbers, tap the Numeric Keyboard button.

For instructions on entering formulas and functions into cells, see Calculate values using data in table cells.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.