Open a presentation 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 at the top of the column or the row number to the left of the row—or select all of the cells in the column or row.
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 Keynote app in the Formula Editor when you’re done.
If you click
You can edit an existing formula so that it refers to different cells.
Go to the Keynote app Format dates, currency, and more in Keynote on Mac