Microsoft KB Archive/181906

= XL98: Paste Function Buttons Missing in Formula Palette =

Article ID: 181906

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q181906



SYMPTOMS
When you are using the Formula Palette in Microsoft Excel 98 Macintosh Edition, 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 98 Function Palette. See the "Workaround" section steps on how to nest functions with the Function Palette.



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



WORKAROUND
To nest functions using the Function Palette in Microsoft Excel 98, do either of the following: Method 1: Example 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" toolbar button on the Standard toolbar. In the Paste Function dialog box, locate the IF function, click in the "Function name" list box, and then click OK.

The Function Palette will be displayed with the IF function. Click the Name Box drop-down, and then click "COUNT" in the list of functions. Note that you may have to click "More Functions" to locate the "COUNT" function.

The Function Palette will now display the arguments for the COUNT function. For the "Value1" argument type the following:

A1:A3

 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 will redisplay the Function Palette with the IF function once again.</li> For the "value_if_true" argument type:

TRUE

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

FALSE

</li> Click OK.

Your 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 in the Formula Bar to include the nested function.

<div class="status_section">

STATUS
This behavior is by design of Microsoft Excel 98.

<div class="references_section">

Formula Palette
and then click Show Topics. Select the "About using the formula palette to enter and edit formulas" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: gray grayed out greyed unavailable XL98

Keywords: kbualink97 kbprb KB181906

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.