XL97: Formula AutoCorrect Inserts Wrong R1C1 Reference

ID: Q185749

The information in this article applies to:

Microsoft Excel 97 for Windows

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          : kbdta xlformula 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: November 5, 1998