Microsoft KB Archive/239981

= Works 2000: Insert Function Cannot Replace Second Argument Correctly =

Article ID: 239981

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2000

-



This article was previously published under Q239981



SYMPTOMS
When you insert a function into a spreadsheet cell, and you select cells to provide data for the arguments, the cell identifiers may not be entered into the arguments correctly. For example:  In a Microsoft Works 2000 spreadsheet, select cell A1. On the Insert menu, click Function. In the Choose a function list, click Count, and then click Insert.

"RangeRef0" is highlighted in the formula. Click cell A2.

"RangeRef0" is replaced by "A2." Press ENTER.

You receive the following error message:

The formula contains an error.

Click OK to return to the formula and correct it.

 Click OK.

"RangeRef1" is highlighted in the formula. Click cell A3.

Note that now only "Ra" is highlighted, and "RangeRef0," which was "A2," is now "A3."</li> Click cell A3 again.

Note that "RangeRef1" now appears as "A3ngeRef1."</li></ol>

<div class="cause_section">

CAUSE
This behavior can occur if the function requires multiple arguments.

<div class="resolution_section">

RESOLUTION
To work around this issue, type the arguments into the formula, and do not attempt to click cells to make them the argument reference. For example:
 * 1) In a Works 2000 spreadsheet, select cell A1.
 * 2) On the Insert menu, click Function.
 * 3) In the Choose a function list, click Count, and then click Insert.
 * 4) In the formula bar, replace all the text between the parentheses with A2,A3.
 * 5) Press ENTER.

The number 2 appears in cell A1, as expected.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: works2k w_works

Keywords: kbbug kbpending kbtshoot KB239981

-

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

© Microsoft Corporation. All rights reserved.