Microsoft Office Tutorials and References

In Depth Information

**Nesting Functions**

You learned earlier that
you can

include a function in a larger formula, like

this formula, which uses the SUM function:

=C12–SUM(A2:C10). You can also use a formula

as an argument for a function, such as the PMT

function, which calculates the monthly payment

for a loan: =PMT(.08/12,60,–12570).

Consider the formula shown in Figure 3-12. It

uses the ROUND function to round the average

of the predicted sales for Quarter 2 to the

nearest whole dollar. Notice that the first argument,

what to round, is the function, AVERAGE. The

second argument, 0, tells the ROUND function

which decimal point to round to.

As they say, that’s not all! You can also use

another function as an argument for the current

function. Now you might be thinking, functions

make me dizzy. Why would I ever want to nest

one function inside another? A popular reason is

to round the result. You learn more about the

ROUND function later in this chapter, but for

now all you need to know is that it rounds a

value (which is its first argument) to a given

number of decimal places (its second argument).

Figure 3-12

Nest one function inside another when needed.