| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use address function to indicate range in calculation
I want to use the address function to indicate the range in the calculation of a slope: cell A2 contains the value 20 =ADDRESS(A2,2) returns $B$20 =ADDRESS(A2,3) returns $C$20 Cell B20 and C20 are the starting cells for calculating the slope: =slope(B20:B25,C20:C25) But putting the address function in the slope calculation, like =slope(ADDRESS(A2,2):B25,ADDRESS(A2,3):C25) does not work! Why can't I combine these functions? Is there another (simple) way? Mayo :( -- Mayo ------------------------------------------------------------------------ Mayo's Profile: http://www.excelforum.com/member.php...o&userid=26371 View this thread: http://www.excelforum.com/showthread...hreadid=508986 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
| MIN Function w/ variable address reference | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Address of named range | Excel Worksheet Functions | |||
Threaded Mode
