Works: Function in Spreadsheet Generates Incorrect Result or Error Message

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q265980

Expand all | Collapse all

SYMPTOMS

When you use a function in a Microsoft Works Spreadsheet document to create a formula, you may experience one of the following symptoms:

The result displayed in the cell is incorrect.

For example, if you type the following in cell A12
=COUNT(A1:A10*2)
where cells A1:A10 contain the value 123, the result in cell A12 is 1 instead of 20.

-or-
You receive the following error message:
The formula contains an error.
Click OK to return to the formula and correct it.

Back to the top

CAUSE

This problem may occur because you cannot perform a multiplication operation inside the parentheses if the parentheses contain a cell range.

Back to the top

To work around this problem, modify the formula so that the parentheses do not contain a cell range.

For example, modify the formula in the "Symptoms" section to appear as follows =COUNT(A1:A10)*2, and then press ENTER.

Back to the top

STATUS

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

Back to the top

APPLIES TO

Microsoft Works 6.0
Microsoft Works 7.0
Microsoft Works Suite 2001
Microsoft Works Suite 2002
Microsoft Works Suite 2003

Back to the top

kbbug kberrmsg kbpending KB265980

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top