Numbers User Guide for iPhone
- Welcome
- What’s new in Numbers 14.1
-
- Get started with Numbers
- Intro to images, graphs and other objects
- Create a spreadsheet
- Open spreadsheets
- Prevent accidental editing
- Personalise templates
- Use sheets
- Undo or redo changes
- Save your spreadsheet
- Find a spreadsheet
- Delete a spreadsheet
- Print a spreadsheet
- Change the sheet background
- Copy text and objects between apps
- Touchscreen basics
- Copyright
![](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150C60D78F13600351D8/en_AU/61e57fb81071150c7da08e52bb0d3db6.png)
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 above the keyboard on the left (if you don’t see
, tap
).
![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.](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150C60D78F13600351D8/en_AU/1e131a04e2de8f34ba6df5c7d946bedb.png)
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 appear.
If you’re unsure which function you need, tap
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
next to it. (The first time you tap
, 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
.
For instructions on entering formulas and functions into cells, see Calculate values using data in table cells in Numbers on iPhone.