Microsoft KB Archive/185747

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

Article ID: 185747

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q185747



SYMPTOMS
Microsoft Excel 98 Macintosh Edition 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 98 Macintosh Edition.

