Numbers allows you to perform all kinds of math — from simple calculations to more advanced statistical functions — using the numbers in your spreadsheet. You can use formulas and functions to process, interpret, and draw conclusions from data sets of any size.
Open the formula editor. Select a cell where you want to add a formula, then type the equal sign (=).
Build a formula. To include a value that appears in another cell in the table, click the cell. A reference to that cell is added to the formula. You can also add other numbers and operators such as +, -, *, or / to construct the formula.
Press Return or click the green checkmark to complete the formula and close the editor. The cell shows the numeric result, not the formula.
Add a mathematical function that displays the maximum value in a list. Select a cell where you want the function to be used, then type the equal sign (=) and click the Format button to open the Functions Browser in the sidebar.
Type “max” in the search field to locate the MAX function. Select MAX in the results list, then click Insert Function.
Once the function appears in the formula editor, click or drag to select table cells containing the numbers you want to include in the calculation, then click the green checkmark .
Explore other functions. Click any function in the Functions Browser to display additional info about it and see examples of how to use it. The info appears at the bottom of the sidebar.
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.
Find the upper and lower range of assignment scores in a grading spreadsheet. Use MAX to reveal the highest value and MIN to reveal the lowest.
You can use Autofill to quickly fill cells with the same formula or data, or a logical sequence of data. Quickly complete a calendar by automatically filling in the dates in a month or the days of the week.
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.