View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sven.halb@gmail.com is offline
external usenet poster
 
Posts: 3
Default Using Dynamic Cell Address As Formula Location

On Mar 5, 10:24 pm, "T. Valko" wrote:
What do you mean by: "use the cell address as a formula location"?

Do you want to use that reference in another formula?

Assume the result of that formula is in cell A1.

Since that formula can return either a blank or a text reference you'd have
to test for the blank:

=IF(A1="",value_if_true,....................)

If A1 does contain the text reference then you need to use the INDIRECT
function to reference it: INDIRECT(A1). Since you didn't describe how you
want to use that reference I don't know how to finish the above IF formula.

Biff

wrote in message

oups.com...



I am using the following formula to return cell address $G$16:
=IF(E110,CELL("address",OFFSET(E17,-1,E17)),"")


I wish to then use the cell address as a formula location...cell
address will change depending on the value in E17.


Appreciate any ideas.


Thanks,
Sven- Hide quoted text -


- Show quoted text -


in the example I wish to populate cell $G$16 with something like
$B5*E11