How to use common functions and formulas in Numbers on Mac and iOS

One of the best features of spreadsheet applications similar Numbers
is its built-in functions in addition to formulas. These handy petty tools allow y'all work
with your numbers much easier. You tin amount a column, teach the maximum lay out in
a row, average a grouping of cells, in addition to more, without doing the calculations
yourself.

While at that spot are many built-in formulas, a handful of them
are used almost often. So, Apple makes these easily accessible inward the Numbers
application. They include sum, average, minimum, maximum, count, in addition to product.

This tutorial shows y'all how to piece of employment amongst these mutual functions
and formulas inward Numbers on both Mac in addition to iOS.

Inserting formulas inward Numbers on Mac

While the spreadsheet we’re using inward our illustration is small,
imagine if y'all bring 1 amongst hundreds of columns or rows. This is when using those
formulas for your calculations is almost valuable.

Inserting the formula y'all desire industrial plant the same trend whether
the values are inward columns, rows, or a grouping of cells.

Start past times selecting the prison theatre cellular telephone where y'all desire the formula and
subsequent upshot displayed. Then, select Insert
> Formula from the carte bar or
the Insert button from the toolbar
and selection the formula. When it pops into your spreadsheet, hitting your Enter key.

Numbers volition gauge at which grouping of cells y'all desire to apply
the formula to; however, y'all tin alter this easily.

Editing the formulas

Double-click the prison theatre cellular telephone containing the formula y'all just
inserted. Influenza A virus subtype H5N1 modest pop-up volition display showing y'all the formula in addition to which cells
it applies to. To alter it, either drag the corners of the hit of cells to
those y'all desire or click within the pop-up in addition to conform the cells past times typing inward the
labels. When y'all finish, click the checkmark
in green.

Getting a quick sentiment of formulas

Maybe y'all desire to teach a sentiment of 1 of the formulas without
actually entering it into the spreadsheet equally a cell. For instance, y'all might
want to encounter the average of a column or the largest lay out inward a grouping of cells.

Select the cells in addition to at the bottom of the Numbers window,
you’ll encounter each of those mutual formulas display automatically. And if at that spot is
one y'all desire to add together to the view, select the gear icon to the correct in addition to choose
the function.

Inserting in addition to editing formulas inward Numbers on iPhone in addition to iPad

If you’re working amongst your spreadsheet on the go, y'all can
insert formulas on your iPhone in addition to iPad equally well.

Select the prison theatre cellular telephone where y'all desire the formula in addition to subsequent
result displayed. Tap the Cell
button on the bottom in addition to conduct New
Formula from the pop-up menu.

You tin in addition to then come inward the formula yourself or fifty-fifty better, tap
the Function (fx) button on the left. You’ll in addition to then see
those mutual formulas in 1 lawsuit again. Tap the 1 y'all desire in addition to it volition popular into the
text expanse at the bottom. Using your finger, drag through the cells y'all desire to
apply the formula to or type them into the text expanse where it shows “value”.
Tap the checkmark inward light-green when you
finish.

Wrapping it up

Working amongst mutual functions in addition to formulas inward Numbers is
much easier than y'all mightiness think. And if y'all utilisation these built-in tools, it can
save y'all fourth dimension in addition to cut back possible errors amongst your data. Are y'all going to give
it a try?

For to a greater extent than how-tos amongst Numbers, cheque out how to freeze columns in addition to rows, merge cells, or transpose items inward your spreadsheet.

Share this post