Microsoft KB Archive/268418

= XL2001: Formulas in Calculated Columns Do Not Match Rows =

Article ID: 268418

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q268418



SYMPTOMS
When you create a calculated column in a list, the formula you use is propagated in every cell in the column relative to the first cell in the column, not the cell in which you attempt to type the formula.



CAUSE
When you select Calculated Column as the data type in the Column Settings dialog box, the column is selected with the top cell made the active cell, which is where the formula is entered.



RESOLUTION
To resolve this issue, use formula references that apply to the first row in the list.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: off2001kb XL2001KB mac xl2001 excel xl formula insert list manager object

Keywords: kbbug kbpending KB268418

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.