Formulas allow you to perform simple calculations using the numbers in your spreadsheet — addition, subtraction, and so on. You can use formulas to process, interpret, and draw conclusions from data sets of any size.
Enter data. Double-tap a cell to enter labels or numeric data.
Open the formula keyboard. Tap the cell where you want the formula, tap Keyboard button, then tap Formula Keyboard button above the keyboard on the right.
Build a formula. To include a value that appears in another cell in the table, tap the cell. A reference to that cell is added to the formula. You can also add other numbers and operators. Tap OK button to complete the formula.
The cell containing the formula now shows the numeric result. If the value in a referenced cell changes, the result of your formula will adjust automatically.
Perform a quick calculation on a range of cells. Select a range of cells by tapping a cell, then dragging one of the blue dots to expand the selection. Tap Cell Action button, then select a quick formula such as Sum, Product, or Average.
Gather data from the world around you. Log data from a local weather source into a spreadsheet that calculates the total weekly rainfall in your neighborhood.
Track your daily physical activity. Create a journal for your favorite exercise (like walking or cycling) to record your distance and time, then calculate your averages.
You can use Autofill to quickly fill cells with the same formula or data, or a logical sequence of data. Try using Autofill to complete a calendar — type the first two dates in a month, then select those cells, tap Cell Actions, and use Autofill to fill in the rest.
Learn more about autofilling cellsShare what you learned and help others discover the Apple Teacher Program.
A link to this page in the Apple Education Community has been copied to your clipboard.