Knowledge Base

XL97: Formula AutoCorrect Inserts Formula with Incorrect R1C1 Cell Reference

Article ID: 185749

Article Last Modified on 10/22/2000

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.

REFERENCES

For more information about the R1C1 reference style in Microsoft Excel 97, click Contents And Index on the Help menu, click the Index button in Microsoft Excel Help, type the following text

R1C1

and then click Show Topics. Select the "R1C1 reference style" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL97 #value!

Keywords: kbprb KB185749