ExcelBanter - Cell Address presents in Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cell Address presents in Formula (https://www.excelbanter.com/excel-worksheet-functions/227028-cell-address-presents-formula.html)

Elton Law[_2_]

Cell Address presents in Formula

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.

Stefi

Cell Address presents in Formula

=ADDRESS(1,1,4,1) returns A1
=CELL("address",A1) returns $A$1
Regards,
Stefi

€žElton Law€ ezt Ã*rta:

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.

All times are GMT +1. The time now is 02:18 AM.