Thread: use address function to indicate range in calculation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mayo
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote