+ Reply to Thread
Results 1 to 2 of 2

Confused about relative references in named formulas

  1. #1

    Confused about relative references in named formulas

    I'm new to this, so perhaps I'm missing something obvious.

    I'm reading the "Excel 2002 Inside Out" book. In the section "Using
    Relative References in Named Formulas" in chapter 12, it mentions a
    sample formula like "=Sheet1!B22+1.2%". It says that if the active cell
    was B21, then the reference to B22 will always translate to the cell
    just below the active cell.

    What bothers me is that the information about what the active cell was
    when the formula was defined is not displayed with the formula. Because
    of that, isn't it impossible for someone to tell by looking at a named
    formula that uses relative references to know what cell the relative
    cell reference refers to? That can't be right, can it?


  2. #2

    Re: Confused about relative references in named formulas

    Ok, never mind. I guess I should have tried it first. What I didn't
    realize is that the display of the named formula in the Define Named
    Formula dialog always shows relative references offset from the
    currently active cell, so the reference in the example wouldn't show
    "B22", it would show the cell address of the cell below the active cell
    (or B22, if the active cell was B21).


+ 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