Open a document with a table, click the cell where you want the result to appear, then type the equal sign (=).
The Formula Editor opens. Drag the left side of the Formula Editor to move it. You can resize it by dragging from any of its outer edges.
Converting the formula to text closes the Formula Editor and leaves the text version of the formula in the cell.
Select an argument in the function, then enter a value or select cells to include in the calculation by doing one of the following:
Select a cell: Click the cell.
Select a range of cells across multiple rows and columns: Drag across the range of cells you want to include.
Add the values of a single row or column: Click the column letter above the column or the row number to the left of the row—or select all of the cells in the row or column.
Press Return or click
You can use comparison operators to check whether the values in two cells are equal, or if one value is greater or less than the other. To do this, you must set up a statement within a cell, for example A1 > A2, meaning the value in cell A1 is greater than the value in cell A2. The result of the comparison operator is expressed as “true” or “false.”
Go to the Pages app , you exit the Formula Editor without saving your changes.
If there’s an error in your formula, on your Mac.
Open a document with a table, then double-click the result cell with the formula you want to edit.
The Formula Editor opens, displaying the functions. Drag the left side of the Formula Editor to move it.
Click the triangle on the token representing the cell range you want to preserve.
You can edit an existing formula so that it refers to different cells.
Go to the Pages app Format dates, currency, and more in Pages on Mac