Datasheet

Figure 1-26 shows the daily closing price for the S&P 500, for the month of
September 2004. A possible analysis is to see how many times the closing
price was higher than the average for the month. Therefore, the average
needs to be calculated first, before you can compare any single price. By
embedding the AVERAGE function inside another function, the average is first
calculated.
When a function is nested inside another, the inner function is calculated
first. Then that result is used as an argument for the outer function.
Figure 1-26:
Nesting
functions.
Figure 1-25:
Math was
never this
easy!
34
Part I: Putting the Fun in Functions
05_046555 ch01.qxp 12/26/06 7:54 PM Page 34