Works 2000: Insert Function Cannot Replace Second Argument Correctly (239981)


The information in this article applies to:

  • Microsoft Works 2000
  • 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:
  1. In a Microsoft 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.

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

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

    You receive the following error message:
    The formula contains an error.

    Click OK to return to the formula and correct it.
  6. Click OK.

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

    Note that now only "Ra" is highlighted, and "RangeRef0," which was "A2," is now "A3."
  8. Click cell A3 again.

    Note that "RangeRef1" now appears as "A3ngeRef1."

CAUSE

This behavior can occur if the function requires multiple arguments.

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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbbug kbpending kbtshoot KB239981
©2004 Microsoft Corporation. All rights reserved.