Microsoft KB Archive/156888

= XL97: Paste Function Buttons Missing in Formula Palette =

Article ID: 156888

Article Last Modified on 10/21/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q156888





SYMPTOMS
When you are using the Formula Palette in Microsoft Excel 97, there are no Paste Function buttons (as there were in earlier versions of Microsoft Excel) for inserting other functions as arguments of the function you are using.

NOTE: This does not prohibit you from nesting functions using the Microsoft Excel 97 Function Palette. See the "Resolution" section steps on how to nest functions with the Function Palette.



CAUSE
The Paste Function buttons were removed from the Function Palette dialog box.



RESOLUTION
To nest functions using the Function Palette in Microsoft Excel 97, 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 click the "Paste Function" button on the Standard toolbar. In the Paste Function dialog box, locate the IF function, click it in the "Function name" list box and then click OK.

The Function Palette is displayed with the IF function. Click the Name Box drop-down 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" (without the quotation marks). In the formula bar, where your nested function is being built, click the IF function text - do NOT click the Name Box drop-down.

This redisplays the Function Palette with the IF function.</li> For the "value_if_true" argument type:

TRUE

</li> For the "value_if_false" argument type:

FALSE

</li> Click OK.

Your the nested function should be as follows

=IF(COUNT(A1:A3),TRUE,FALSE)

and, for this example, returns a value of TRUE.</li></ol>

Method 2: Manually Edit the Formula
Manually edit the formula in the formula bar to include the nested function.

<div class="references_section">