Microsoft Office Tutorials and References
In Depth Information
To nest one function in another, follow these
4. Enter the arguments for the main function,
separated by commas. If the argument is a
function itself, type the function name (such
as AVERAGE) and the function’s arguments,
enclosed in parentheses. For example, you
could type =ROUND(AVERAGE(A2:G4).
1. Click in the cell where you want the result of
the formula to appear.
2. Type the equals sign (=).
5. After entering the arguments for the main
function and for any nested functions, type
the closing parenthesis and press Enter. For
example, your completed formula might look
like this: =ROUND(AVERAGE(A2:G4),2). The
result of your formula appears in the result
cell selected in Step 1.
3. Begin entering the main function, either by
typing its name and an opening parenthesis,
clicking the Insert Function button and
selecting the function, or selecting the function
from the AutoSum list. For example, type
Order of Operations
Remember that Excel solves a formula by
performing the innermost calculations ﬁrst,
and then moving outwards. So the main
function in this case is the one you want
performed last , after the other function has
been calculated. To round the result of a
function, you want ROUND performed last,
so it’s treated as the main function and
entered ﬁrst into the formula.
Probably the most common mistake
when nesting functions is to forget the
closing parenthesis for the function,
whether it’s the main function or a nested
one. Excel typically catches such mistakes
and makes a guess as to where you want
the closing parenthesis to go, so you won’t
usually get an error when you forget one.
However, keep in mind that this is only a
guess, and in my experience, it’s often
a wrong one. So be sure to check your
formula to make sure the parentheses
are where they should be, or you might
get an incorrect result.