One of the best features of spreadsheet applications like Numbers
is its built-in functions and formulas. These handy little tools let you work
with your numbers much easier. You can sum a column, get the maximum number in
a row, average a group of cells, and more, without doing the calculations
While there are many built-in formulas, a handful of them
are used most often. So, Apple makes these easily accessible in the Numbers
application. They include sum, average, minimum, maximum, count, and product.
This tutorial shows you how to work with these common functions
and formulas in Numbers on both Mac and iOS.
Inserting formulas in Numbers on Mac
While the spreadsheet we’re using in our example is small,
imagine if you have one with hundreds of columns or rows. This is when using those
formulas for your calculations is most valuable.
Inserting the formula you want works the same way whether
the values are in columns, rows, or a group of cells.
Start by selecting the cell where you want the formula and
subsequent result displayed. Then, select Insert > Formula from the menu bar or
the Insert button from the toolbar
and pick the formula. When it pops into your spreadsheet, hit your Enter key.
Numbers will guess at which group of cells you want to apply
the formula to; however, you can change this easily.
Editing the formulas
Double-click the cell containing the formula you just
inserted. A small pop-up will display showing you the formula and which cells
it applies to. To change it, either drag the corners of the range of cells to
those you want or click inside the pop-up and adjust the cells by typing in the
labels. When you finish, click the checkmark in green.
Getting a quick view of formulas
Maybe you want to get a view of one of the formulas without
actually entering it into the spreadsheet as a cell. For instance, you might
want to see the average of a column or the largest number in a group of cells.
Select the cells and at the bottom of the Numbers window,
you’ll see each of those common formulas display automatically. And if there is
one you want to add to the view, select the gear icon to the right and choose
Inserting and editing formulas in Numbers on iPhone and iPad
If you’re working with your spreadsheet on the go, you can
insert formulas on your iPhone and iPad as well.
Select the cell where you want the formula and subsequent
result displayed. Tap the Cell button on the bottom and choose New
Formula from the pop-up menu.
You can then enter the formula yourself or even better, tap
the Function (fx) button on the left. You’ll then see
those common formulas once again. Tap the one you want and it will pop into the
text area at the bottom. Using your finger, drag through the cells you want to
apply the formula to or type them into the text area where it shows “value”.
Tap the checkmark in green when you
Wrapping it up
Working with common functions and formulas in Numbers is
much easier than you might think. And if you use these built-in tools, it can
save you time and reduce possible errors with your data. Are you going to give
it a try?