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 Need Countifs Formula Help 0
Formula for Cell address 3
Locking a cell reference in a formula 1
Two functions in one formula. 1
Return formula in cell 2
Remove punctuation mark, Split cells & average accross column 4
If and value between two numbers 6
Formula Working With Positives and Negatives 2

Top