Change an existing formula in Keynote for iCloud
You can edit an existing formula so that it refers to different cells.
Double-click the results cell with the formula you want to edit.
The formula editor opens displaying the functions.
Do any of the following:
Add more cell references: Place the insertion point within the argument area for the function, then select the new cells you want to add.
Remove cell references: Place the insertion point within the argument area for the function, select the unwanted cell references, then press Delete.
Change the cell references: Click the existing cell addresses you want to change to select them, then select the new cells.
Press Return or click the Checkmark button
in the formula editor when you’re done.If you click the Cancel button
, you exit the current cell without saving the formula in it.