Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to set up a simple variable in Excel, but cell location independent
Can you please show me how to set up a simple variable in Excel, but this
variable must be cell location independent. Because this worksheet will be sorted and cell location re-arranged and moved. That mean for example, In one worksheet, I set variable numb = 5 other cell at different location value display will have function such as numb*2 = 5*2 = 10 Then, other time, I set this same variable numb = 12 then, the call value will display numb*2 = 12*2 = 24 Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Regression using more than 1 independent variable | Excel Discussion (Misc queries) | |||
CELL LOCATION!! SIMPLE QUESTION!!!! | Excel Discussion (Misc queries) | |||
add a second independent variable, doing regression in excel? | Excel Discussion (Misc queries) | |||
Simple way to get cell location as text "A2" | Excel Worksheet Functions | |||
Two Independent Variable Correlation | Excel Discussion (Misc queries) |