formulas are reading weird

[Guest]

when I click on the function key and try to input a formula by clicking on
different cells (ie B6, C3), the formula records something wacky....like
[RC]-1,[RC]C. Please help so I can track the formula in the future and
others can see where the calculations are coming from. If I type the exact
number, it's ok. But I want to be able to click on the cells instead.

 

[Frank Kabel]

Hi
goto 'Tools - Options - General' and uncheck 'R1C1 reference style'

--
Regards
Frank Kabel
Frankfurt, Germany

when I click on the function key and try to input a formula by clicking on
different cells (ie B6, C3), the formula records something wacky....like
[RC]-1,[RC]C. Please help so I can track the formula in the future and
others can see where the calculations are coming from. If I type the exact
number, it's ok. But I want to be able to click on the cells

instead.

 

[Biff]

Hi!

It sounds like you are using the R1C1 reference style.

Are your column headers numbers and not letters?

To change it goto Tools>Options>General Tab.
Uncheck R1C1 reference style.

Biff

 

[Max]

Try ..

Click Tools > Options > General tab
Uncheck "R1C1 reference style" > OK