Microsoft KB Archive/265980

= Works: Function in Spreadsheet Generates Incorrect Result or Error Message =

Article ID: 265980

Article Last Modified on 1/27/2007

-

APPLIES TO


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

-



This article was previously published under Q265980



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.





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



RESOLUTION
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 &quot;Symptoms&quot; section to appear as follows =COUNT(A1:A10)*2, and then press ENTER.



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: works6 w_works

Keywords: kbbug kberrmsg kbpending KB265980

-

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

© Microsoft Corporation. All rights reserved.