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)
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)
>
>
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)
>
>
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)
>
>
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)
>
>
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)
>
>
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)
>
>
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)
>
>
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)
>
>
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)
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks