Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference a cell containing a Reference
From my graph i generated, a starting point along the x is required to make
the necessary calculations. Since the x starting point is changing, i therefore have to keep changing the value from A607 to A607-24 hours each day because of the new 24 points each taken on hour intervals. I wish to be able to open my excel document in x number of days. See on the graph i need to start at 300 hours. which is A(300+3) due to title on data and such. Is there a way i can enter in a cell "300" for the hour, then have all my formulas know that i want to start A303 for my xrange instead??? ie =EXP(INTERCEPT(LN(AK607):AK2187),A607:A2187)) Tomorrow i may want to start at AK533 Can i insert 530 into a cell, then have another cell say "AK533" then insert that into the AK607 part of the forumla?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference a cell containing a Reference
Are you sure the formula as you wrote it here is working? I get error messages. but basically, the Indirect() function should replace what you reference to a specific cell.. e.g. =Indirect("AK"&A1) would return value in AK533 if A1 houses 533. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=558885 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
cell reference changes and conditional formatting | Excel Worksheet Functions | |||
How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions |