XL98: Formula AutoCorrect Inserts Formula with Incorrect R1C1 Cell Reference

ID: Q185747

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

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

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: XL98

Keywords : kbdta xlformula
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb