Quickly calculate a sum, average and more in Numbers on iPhone

You can make calculations in your table without having to insert a formula or function.

Make quick calculations for a range of cells

  1. Go to the Numbers app on your iPhone.

  2. In a spreadsheet, select the column or row (or the range of cells) whose calculations you want to see.

  3. Tap the Cell Action menu button at the bottom of the screen, then tap the formula you want to use.

    If you selected an entire column or row, tap the Column Action menu button or the Row Action menu button, then tap the formula you want to use.

    The result of the formula appears at the end of your selection.

Use the Formula Editor like a calculator

You can enter number values in formulas to make calculations, just as you would on a calculator.

  1. Go to the Numbers app on your iPhone.

  2. In a spreadsheet, tap a blank cell where you want to add your formula, then type the equal sign (=) to open the Formula Editor.

  3. 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.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.