Numbers
You can make calculations in your table without having to insert a formula or function.
Go to the Numbers app on your Mac.
In a spreadsheet, select the column or row (or the range of cells) whose calculations you want to see.
Calculations for the selected cells—for example, the sum, average, minimum, maximum—appear at the bottom of the window.
To add a formula with the calculation to your table, drag the calculation to a table cell.
You can add or remove the functions you see when you select a range of cells.
Go to the Numbers app on your Mac.
In a spreadsheet, select the column or row (or the range of cells) whose calculations you want to see.
Click , then choose the functions you want to add or remove.
You can enter number values in formulas to make calculations, just as you would in a calculator.
Go to the Numbers app on your Mac.
In a spreadsheet, click a blank cell where you want to add your formula, then type the equal sign (=) to open the Formula Editor.
Type the equation you want to calculate, using values and arithmetic operators (for example, +,-,*, and /).
For example, if you type the equal sign (=), then type “1+1” in the Formula Editor, the cell returns the result of 2. You can also use parentheses; if you type 4+6*(3-1), the cell returns the result of 16.