Microsoft Office Tutorials and References

In Depth Information

**Nesting Functions**

To nest one function in another, follow these

steps:

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

=ROUND(
.

Order of Operations

Tip

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.