Works: Function in Spreadsheet Generates Incorrect Result or Error Message (265980)

The information in this article applies to:

Microsoft Works 6
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 "Symptoms" 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.

Modification Type:	Major	Last Reviewed:	11/24/2003
Keywords:	kbbug kberrmsg kbpending KB265980