Microsoft Office Tutorials and References
In Depth Information
Using Nested Functions
For example, click the Logical & Reference button, and then click COUNTIF.
Excel inserts the function you selected into the formula bar with a set of paren-
thesis, and opens the Function Arguments dialog box.
Type a function as an argument to create a nested function, or a regular argu-
For example, =COUNTIF(E6:E19), “>”&AVERAGE(E6:E19)).
Click OK .