Formula appears as =RC[-3]+RC[-1] Whats this?

[Concrete Guy]

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????

[Bob Phillips]

Tools>Options>General>R1C1 Reference Style, uncheck it

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Concrete Guy" <Concrete Guy@discussions.microsoft.com> wrote in message
news:6603D7DD-9EC9-42DF-851F-17D3C7C8073F@microsoft.com...
> 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????