Microsoft Office Tutorials and References
In Depth Information
Nesting Functions
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.
Search JabSto ::

Custom Search