XL97: Formula AutoCorrect Inserts Formula with Incorrect R1C1 Cell Reference (185749)
The information in this article applies to:
- Microsoft Excel 97 for Windows
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
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.
Modification Type: | Major | Last Reviewed: | 10/22/2000 |
---|
Keywords: | kbprb KB185749 |
---|
|