Datasheet

12. Click OK or press Enter to complete the function.
Figure 1-25 shows the result of all this hoopla. The PRODUCT function returns
the result of the individual numbers being multiplied together.
You do not have to use the Insert Function dialog box to enter functions into
cells. It is there for convenience. As you become familiar with certain func-
tions that you use repeatedly, you may find it faster to just type the function
directly into the cell.
Nesting functions
Nesting is something a bird does, isn’t it? Well, a bird expert would know the
answer to that one, but we do know how to nest Excel functions. A
nested
function
is tucked inside another function, as one of its arguments. Nesting
functions let you return results you would have a hard time getting to other-
wise. (Nested functions are used in examples in various places in the book.
The COUNTIF, AVERAGE, and MAX functions are discussed in Chapter 9.)
Figure 1-24:
Completing
the function
entry.
Figure 1-23:
Using
RefEdit
to enter
arguments.
33
Chapter 1: Tapping into Formula and Function Fundamentals
05_046555 ch01.qxp 12/26/06 7:54 PM Page 33