XL98: Formula AutoCorrect Inserts Formula with Incorrect R1C1 Cell Reference (185747)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
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.
REFERENCES
For more information about the R1C1 cell reference style in Microsoft Excel
98 Macintosh Edition, click Contents And Index on the Help menu (or on the
Balloon Help menu if you are using a version of the Macintosh operating
system earlier than 8.0), click the Index button in Microsoft Excel 98
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: | 9/11/2002 |
|---|
| Keywords: | kbprb KB185747 |
|---|
|