To nest functions using the Function Palette in Microsoft Excel 2000, use either of the following methods.
Method 1: Using the Name Box on the Formula Bar
- Enter the following on a new worksheet:
A1: 1
A2:
A3: 1
- Select cell B1, and then click the Paste Function button on the Standard toolbar.
- In the Paste Function dialog box, select the IF function in the Function name list, and then click OK.
The Function Palette is displayed with the IF function.
- Click the arrow next to the function box, and then click COUNT in the list of functions.
NOTE: You may have to click More Functions to locate the COUNT function.
The Function Palette now displays the arguments for the COUNT function.
- For the Value1 argument, type A1:A3.
- In the formula bar, where your nested function is being built, click the IF function text; do not click any items in the function box drop-down list.
This redisplays the Function Palette with the IF function.
- For the Value_if_true argument, type TRUE.
- For the Value_if_false argument, type FALSE.
- Click OK.
Your nested function should be as follows
=IF(COUNT(A1:A3),TRUE,FALSE)
and, for this example, returns a value of TRUE.
Method 2: Manually Edit the Formula
Manually edit the formula in the formula bar to include the nested function.