A2 cell reference increment

1. A2 cell reference increment

I want to reference a cell using some math:

\$B(1+1) which I would hope equals \$B2 and the cell would then contain a reference to \$B2.

How does one perform math funtions to the row part of a reference?

I what to be able to reference a cell that contains a cell reference

So Cell A1 would contain the text B12

cell A2 would reference to cell A1 and show the contents of B12.

and in cell A3, I want to show the contents of B13... but I want to take the contents of cell A1 and increment it from B12 to B13...

How do I do that? I tried simple math like \$B(1+1) which does not equal \$B2.

Thanks for a newbie question,

Chris

2. Re: A2 cell reference increment

You could use the Indirect function. Eg:
= Indirect(A1)

Hope this helps
Rowan

cejones wrote:
> I want to reference a cell using some math:
>
> \$B(1+1) which I would hope equals \$B2 and the cell would then contain
> a reference to \$B2.
>
> How does one perform math funtions to the row part of a reference?
>
>
> I what to be able to reference a cell that contains a cell reference
>
> So Cell A1 would contain the text B12
>
> cell A2 would reference to cell A1 and show the contents of B12.
>
> and in cell A3, I want to show the contents of B13... but I want to
> take the contents of cell A1 and increment it from B12 to B13...
>
> How do I do that? I tried simple math like \$B(1+1) which does not
> equal \$B2.
>
> Thanks for a newbie question,
>
> Chris
>
>

3. Re: A2 cell reference increment

well I'm confused but I will try to help:
in A1 type =B12
if you want to join cells together:
=B1&B2&B3
IF YOU WANT TO ADD CELLS TOGETHER:
=B1+B2+B3
IF YOU WANY TO ADD TO A REFERENCE CELL
=B1+1
IF YOU WANT TO ADD TEXT TO A CELL AND A REFERENCE CELL
=B1&"HELLO"&B2+1

4. Re: A2 cell reference increment

Don't quite follow you, but does this info help?

Cell A1 contains the text,
B12

Cell A2 contains the number,
50

Cell B12 contains the number,
100

Cell B13 contains the number,
222

=Indirect(A1)
Returns 100

=Indirect("A1")
Returns B12
*BUT* ... that B12 is *TEXT*!

SO,
=Offset(B12,1,)
Returns 222

However,
=Offset(Indirect("A1"),1,)
Returns 50

While,
=Offset(Indirect(A1),1,)
Returns 222

Not too confusing, is it?<g>
--
HTH,

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

"cejones" <cejones.1y5kpb_1131411001.383@excelforum-nospam.com> wrote in
message news:cejones.1y5kpb_1131411001.383@excelforum-nospam.com...
>
> I want to reference a cell using some math:
>
> \$B(1+1) which I would hope equals \$B2 and the cell would then contain
> a reference to \$B2.
>
> How does one perform math funtions to the row part of a reference?
>
>
> I what to be able to reference a cell that contains a cell reference
>
> So Cell A1 would contain the text B12
>
> cell A2 would reference to cell A1 and show the contents of B12.
>
> and in cell A3, I want to show the contents of B13... but I want to
> take the contents of cell A1 and increment it from B12 to B13...
>
> How do I do that? I tried simple math like \$B(1+1) which does not
> equal \$B2.
>
> Thanks for a newbie question,
>
> Chris
>
>
> --
> cejones
> ------------------------------------------------------------------------
> cejones's Profile:

http://www.excelforum.com/member.php...fo&userid=1220
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1