XL97: Array Formula Using Merged Cells 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

Additional query words: XL97

Keywords          : xlformat xlformula 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: November 5, 1998