Cell address as return value

English
, ,
#1

I need a sell adress as return value of the function(or some way for it to appear in a current cell ). How can i do that?

#2

Does this work for you? Place it in cell A1.

=ADDRESS(ROW(A1),COLUMN(A1),4)
#3

There is a function returning the address of the cell: =CELL("ADDRESS")

Please take a look in the help to see what other information this function can give.

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.