Cell Address presents in Formula

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.
 
S

Stefi

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

„Elton Law†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Formula for Cell address 3
Formula to answer YES or No 4
Remove punctuation mark, Split cells & average accross column 4
Copy addition formula of non-consecutive horizontal cells 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Locking a cell reference in a formula 1
Help with an if then scenario 2

Top