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

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!
==============================================


"Streep" <[email protected]> wrote in message
news:[email protected]...
> 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)

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


"RagDyer" wrote:

> 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!
> ==============================================
>
>
> "Streep" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>

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!
=====================================================


"Streep" <[email protected]> wrote in message
news:[email protected]...
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


"RagDyer" wrote:

> 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!
> ==============================================
>
>
> "Streep" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>

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!
==============================================


"Streep" <[email protected]> wrote in message
news:[email protected]...
> 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)

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


"RagDyer" wrote:

> 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!
> ==============================================
>
>
> "Streep" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>

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!
=====================================================


"Streep" <[email protected]> wrote in message
news:[email protected]...
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


"RagDyer" wrote:

> 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!
> ==============================================
>
>
> "Streep" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>

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)

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!
==============================================


"Streep" <[email protected]> wrote in message
news:[email protected]...
> 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)

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


"RagDyer" wrote:

> 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!
> ==============================================
>
>
> "Streep" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>

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!
=====================================================


"Streep" <[email protected]> wrote in message
news:[email protected]...
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


"RagDyer" wrote:

> 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!
> ==============================================
>
>
> "Streep" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>