![]() |
Formula appears as =RC[-3]+RC[-1] Whats this?
I am getting formula formatted as =RC[-3]+RC[-1] when simple Row and Column
references is what I desire to see. I don't know how to interpret the formula as shown when I select that cell. I type in the typical Row/Cell location but it gets displayed as above. an anyone help???? |
Formula appears as =RC[-3]+RC[-1] Whats this?
ToolsOptionsGeneralR1C1 Reference Style, uncheck it
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Concrete Guy" <Concrete wrote in message ... I am getting formula formatted as =RC[-3]+RC[-1] when simple Row and Column references is what I desire to see. I don't know how to interpret the formula as shown when I select that cell. I type in the typical Row/Cell location but it gets displayed as above. an anyone help???? |
All times are GMT +1. The time now is 02:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com