+ Reply to Thread
Results 1 to 4 of 4

A2 cell reference increment

  1. #1
    Registered User
    Join Date
    10-01-2003
    Posts
    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. #2
    Rowan Drummond
    Guest

    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. #3
    damorrison
    Guest

    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. #4
    RagDyer
    Guest

    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
    > View this thread: http://www.excelforum.com/showthread...hreadid=483007
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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