XL97: Array Formula Using Merged Cells Is Calculated Incorrectly

ID: Q173954

The information in this article applies to:
  • Microsoft Excel 97 for Windows

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 : xlformat xlformula
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: October 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.