Article ID: 173954
Article Last Modified on 10/21/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q173954
SYMPTOMS
When you enter a formula in a worksheet, some of the values that are returned by the formula may be incorrect.
CAUSE
This problem may occur when the following conditions are true:
- You enter the formula as an array formula (press CTRL+SHIFT+ENTER). -and-
- The formula refers to one or more merged cells.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97.
REFERENCES
For more information about merging cells, click the Index tab in Microsoft Excel Help, type the following text
merging, cells
and then double-click the selected text to go to the "Merge cells to span several columns or rows" topic.
Additional query words: XL97
Keywords: kbbug KB173954