Excel trouble

[Albatross]

so,i want to offset the address of the result of a formula ,something like this:


=OFFSET(CELL("ADRESS",E5),1,0)

for some reson it doesnt work,any excel gurus can help?

 

[Albatross]

EDIT:

Also,tried this:
=OFFSET(INDIRECT(ADDRESS(5,5,4,TRUE)),1,0)
but it gives me an offset to the cell in which the result is,not to its address.
anybody?

 

[CycloWizard]

I'm not really sure what you're trying to do, but this link seems to explain it pretty thoroughly:
http://www.techonthenet.com/excel/formulas/offset.php