Cell Address presents in Formula

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

Elton Law

Hi all,
A1 is a number showing 100.
Using formula =(A1) in cell A2 is equal to 100. This is obvious.
What formula can use so that it can give the cell reference or address of
the cell A1 please ?
That is A1 rather than 100.
Thanks indeed.
 
=ADDRESS(1,1,4,1) returns A1
=CELL("address",A1) returns $A$1
Regards,
Stefi

„Elton Law†ezt írta:
 
Back
Top