Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas are reading weird
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. |
#2
|
|||
|
|||
Hi
goto 'Tools - Options - General' and uncheck 'R1C1 reference style' -- Regards Frank Kabel Frankfurt, Germany "darcerella" schrieb im Newsbeitrag ... 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. |
#3
|
|||
|
|||
Hi!
It sounds like you are using the R1C1 reference style. Are your column headers numbers and not letters? To change it goto ToolsOptionsGeneral Tab. Uncheck R1C1 reference style. Biff -----Original Message----- 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. . |
#4
|
|||
|
|||
Try ..
Click Tools Options General tab Uncheck "R1C1 reference style" OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "darcerella" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |