LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Regression using more than 1 independent variable ALEX Excel Discussion (Misc queries) 2 February 1st 07 06:29 AM
CELL LOCATION!! SIMPLE QUESTION!!!! HERNAN Excel Discussion (Misc queries) 3 October 18th 06 06:55 PM
add a second independent variable, doing regression in excel? cheeks Excel Discussion (Misc queries) 1 April 3rd 06 12:03 AM
Simple way to get cell location as text "A2" cKBoy Excel Worksheet Functions 4 February 17th 06 05:28 AM
Two Independent Variable Correlation MillerK Excel Discussion (Misc queries) 1 April 21st 05 03:50 AM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"