Article ID: 211577 - View products that this article applies to.
This article was previously published under Q211577
This article has been archived. It is offered "as is" and will no longer be updated.
When you are using the Formula Palette in Microsoft Excel 2000, there are no Paste Function buttons (as there were in versions of Microsoft Excel earlier than Excel 97) for inserting other functions as arguments of the function you are using.
NOTE: This does not prohibit you from nesting functions by using the Microsoft Excel 2000 Function Palette. See the "Resolution" section for steps on how to nest functions with the Function Palette.
The Paste Function buttons were removed from the Function Palette dialog box.
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
=IF(COUNT(A1:A3),TRUE,FALSE)and, for this example, returns a value of TRUE.
Method 2: Manually Edit the FormulaManually edit the formula in the formula bar to include the nested function.
For more information about the Formula Palette, click Microsoft Excel Help on the Help menu, type About using the Formula Palette to enter and edit formulas in the Office Assistant or the Answer Wizard, and then click Search to view the topic.