function CELL() to return the formula in the referenced cell

S

Streep

Is there a function that returns the formula in a cell?
Example:
Cell C3 contains the formula =Rates!D4
I need a formula that returns this in such a format that I can convert the
contents to =Rates!D5 or infact to =Rates!D(4+1)
 
R

RagDyer

If you select C3 and click on the "fill handle" (little black square in
lower right corner of cell), and drag down to the next (C4) cell, you'll get
the
=Rates!D4
to change to
=Rates!D5

Is that not good enough?

=Rates!D(4+1)
*Doesn't* accomplish anything in XL!
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
S

Streep

No, no good enough.
What happens if I do not drag down to C4 but drag right to D3.. ?
I will still not get =Rates!D5

rgds
 
R

RagDyeR

You didn't say that at the outset.

If you wish to copy *across* columns, along a row, try this in C3:

=INDEX(Rates!$D:$D,COLUMN(C:C))

And as you drag across Row3, you'll get D4, D5, D6 ... etc.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


No, no good enough.
What happens if I do not drag down to C4 but drag right to D3.. ?
I will still not get =Rates!D5

rgds
 
Top