Microsoft KB Archive/185749

= XL97: Formula AutoCorrect Inserts Formula with Incorrect R1C1 Cell Reference =

Article ID: 185749

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q185749



SYMPTOMS
Microsoft Excel 97 may insert an incorrect formula when you use the Formula AutoCorrect feature.



CAUSE
This problem occurs when you use the R1C1 cell reference style in a formula. For example, the following formula

=IF(AND(R2C1="a",R3C1="b"),1,0

is changed by the Formula AutoCorrect feature to the following formula:

=IF(AND(RC21="a",RC31="b"),1,0)

NOTE: In the first example formula, the last parenthesis is missing because it causes Excel to use the Formula AutoCorrect feature.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows.

