XL97: Array Formula Using Merged Cells Is Calculated Incorrectly (173954)
The information in this article applies to:
- Microsoft Excel 97 for Windows
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
and then double-click the selected text to go to the "Merge cells to span
several columns or rows" topic.
Modification Type: | Major | Last Reviewed: | 10/21/2000 |
---|
Keywords: | kbbug KB173954 |
---|
|