Hi, is there a formula that would have as it's output the cell address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell reference A10.

I'm hoping that this should be simple.

--
Creator

so... you want cell "A10" to read "A10"? I don't think I understand your post.
--
"I''m just a simple man trying to make my way in the universe..."


"Creator" wrote:

Hi, is there a formula that would have as it's output the cell address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell reference A10.

I'm hoping that this should be simple.

--
Creator

=CELL("address",A1)

Vaya con Dios,
Chuck, CABGx3


"Creator" wrote:

Hi, is there a formula that would have as it's output the cell address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell reference A10.

I'm hoping that this should be simple.

--
Creator

Thanks for your response.

Can it be done without A1 appearing in the formula?
--
Creator


"CLR" wrote:

=CELL("address",A1)

Vaya con Dios,
Chuck, CABGx3


"Creator" wrote:

Hi, is there a formula that would have as it's output the cell address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell reference A10.

I'm hoping that this should be simple.

--
Creator

Yes, if you first give A1 a RangeName.........Insert Name Define.....type
in say, MyCell......

then this formula, anywhere, will return $A$1.........

=CELL("address",MyCell)

Vaya con Dios,
Chuck, CABGx3





"Creator" wrote:

Thanks for your response.

Can it be done without A1 appearing in the formula?
--
Creator


"CLR" wrote:

=CELL("address",A1)

Vaya con Dios,
Chuck, CABGx3


"Creator" wrote:

Hi, is there a formula that would have as it's output the cell address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell reference A10.

I'm hoping that this should be simple.

--
Creator

Ok, thanks again for indulging but I don't want any reference in the formula
to the current cell address, whether by name or otherwise. I want to use this
formula over many ranges. Is this possible? It's kinda like the cell asking
itself "=who am I?"
--
Creator


"CLR" wrote:

Yes, if you first give A1 a RangeName.........Insert Name Define.....type
in say, MyCell......

then this formula, anywhere, will return $A$1.........

=CELL("address",MyCell)

Vaya con Dios,
Chuck, CABGx3





"Creator" wrote:

Thanks for your response.

Can it be done without A1 appearing in the formula?
--
Creator


"CLR" wrote:

=CELL("address",A1)

Vaya con Dios,
Chuck, CABGx3


"Creator" wrote:

Hi, is there a formula that would have as it's output the cell address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell reference A10.

I'm hoping that this should be simple.

--
Creator

This formula will return the address of the same cell that this formula is
in.....

=CELL("address")

Vaya con Dios,
Chuck, CABGx3



"Creator" wrote:

Ok, thanks again for indulging but I don't want any reference in the formula
to the current cell address, whether by name or otherwise. I want to use this
formula over many ranges. Is this possible? It's kinda like the cell asking
itself "=who am I?"
--
Creator


"CLR" wrote:

Yes, if you first give A1 a RangeName.........Insert Name Define.....type
in say, MyCell......

then this formula, anywhere, will return $A$1.........

=CELL("address",MyCell)

Vaya con Dios,
Chuck, CABGx3





"Creator" wrote:

Thanks for your response.

Can it be done without A1 appearing in the formula?
--
Creator


"CLR" wrote:

=CELL("address",A1)

Vaya con Dios,
Chuck, CABGx3


"Creator" wrote:

Hi, is there a formula that would have as it's output the cell address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell reference A10.

I'm hoping that this should be simple.

--
Creator

Creator wrote...
Ok, thanks again for indulging but I don't want any reference in the formula
to the current cell address, whether by name or otherwise. I want to use this
formula over many ranges. Is this possible? It's kinda like the cell asking
itself "=who am I?"

If you want the address of the cell in that cell's formula, then if you
use CELL("Address",..) you *MUST* put that cell's address in the CELL
call as 2nd argument. But this is *not* a problem since if cell B2
contained =CELL("Address",B2), B2 were copied and pasted into cell D7,
then the formula in cell D7 would be =CELL("Address",D7).

If your concern is manually entering such a term in formulas, then
switch to R1C1-style addressing when entering such formulas and enter
=CELL("Address",RC), then switch back to A1-style addressing
afterwards. Alternatively, if you enjoy unnecessary typing exercises,
you could use =ADDRESS(ROW(),COLUMN()).