Formula plus text in a cell question

Discussion in 'Word Tables' started by enigmaes, Jul 25, 2012.

  1. enigmaes

    enigmaes Guest

    Complicated, but here we go.

    I have a document (close to 300 pgs) that is line-numbered for qualit
    control. I put the number 1 in the first line, and every line belo
    that I used a formula: "=MAX(ABOVE)+1" to create the line numbers.
    This way, I can add lines in the middle, and the numbers can be redon
    in a few keystrokes.

    Fine.

    After that, I need to reference the line numbers in other parts of th
    document. So, I highlight the line number, which encompasses th
    formula, and give it a bookmark label. Again, fine.

    When I need to reference it, I type text around it, so that it look
    like

    Also see section 500.2, (# )

    After the # sign, I insert a formula that says "=ABS(bookmark)" Thi
    works great, because if I throw more lines in the middle, the reference
    automatically update.

    so, here's the question -

    What if I have TWO sections to reference that are on different lin
    numbers?

    Also see section 500.2 (#)
    And see section 500.3 (#)?

    IS there a way to get two different values returned?
    =if(abs(bookmark1) not equal to abs(bookmark2),abs(bookmark1)"
    "(Bookmark2)," ")
    or something.... How do I do that?

    TIA


    --
    enigmaes
     
    enigmaes, Jul 25, 2012
    #1
    1. Advertisements

  2. enigmaes

    Stefan Blom Guest

    As you have noticed, traffic isn't what it used to be in this newsgroup. The
    reason is that many people have moved on to Microsoft forums. Your best option
    is to repeat the question at the Office Answers programming forum (see
    http://answers.microsoft.com/en-us/office/forum/customize?page=1&tab=all).
    Alternatively, try one of the MSDN or TechNet forums (for example
    http://social.msdn.microsoft.com/Forums/en-US/categories).

    --
    Stefan Blom
    Microsoft Word MVP





    "enigmaes" <mextx(_DELETETHIS_)@YAHOO.COM> wrote in message
    news:...
    >
    > Complicated, but here we go.
    >
    > I have a document (close to 300 pgs) that is line-numbered for quality
    > control. I put the number 1 in the first line, and every line below
    > that I used a formula: "=MAX(ABOVE)+1" to create the line numbers.
    > This way, I can add lines in the middle, and the numbers can be redone
    > in a few keystrokes.
    >
    > Fine.
    >
    > After that, I need to reference the line numbers in other parts of the
    > document. So, I highlight the line number, which encompasses the
    > formula, and give it a bookmark label. Again, fine.
    >
    > When I need to reference it, I type text around it, so that it looks
    > like
    >
    > Also see section 500.2, (# )
    >
    > After the # sign, I insert a formula that says "=ABS(bookmark)" This
    > works great, because if I throw more lines in the middle, the references
    > automatically update.
    >
    > so, here's the question -
    >
    > What if I have TWO sections to reference that are on different line
    > numbers?
    >
    > Also see section 500.2 (#)
    > And see section 500.3 (#)?
    >
    > IS there a way to get two different values returned?
    > =if(abs(bookmark1) not equal to abs(bookmark2),abs(bookmark1)"
    > "(Bookmark2)," ")
    > or something.... How do I do that?
    >
    > TIA!
    >
    >
    >
    >
    > --
    > enigmaes
     
    Stefan Blom, Jul 29, 2012
    #2
    1. Advertisements

  3. Hi,

    [Word version?]

    > I have a document (close to 300 pgs) that is line-numbered
    > for quality control. I put the number 1 in the first line, and
    > every line below that I used a formula: "=MAX(ABOVE)+1"
    > to create the line numbers.
    > This way, I can add lines in the middle, and the numbers can
    > be redone in a few keystrokes.


    Do you mean exactly text "lines"? You could use Line numbering (Page
    setup | Layout).
    Do you mean "paragraphs" (where each paragraph is a line)? You could
    use paragraph numbering.
    Do you mean table rows? You also could use paragraph numbering within a
    separate column.

    > After that, I need to reference the line numbers in other
    > parts of the document.


    I guess, that's the reason why you don't use Line numbering...

    If paragraph numbering (which can be cross-referenced) is not a choice
    for you, may be Captions are an alternative:
    Create a new label "line". Enable "Exclude label from caption". Replace
    all your formulas by a field: { SEQ line}
    Now you can cross-reference to those caption numbers, without having to
    apply any bookmark by yourself.

    > What if I have TWO sections to reference that are on
    > different line numbers?
    > Also see section 500.2 (#)
    > And see section 500.3 (#)?


    > IS there a way to get two different values returned?
    > =if(abs(bookmark1) not equal to abs(bookmark2),
    > abs(bookmark1)" "(Bookmark2)," ")


    Did you try { If bookmark1 <> bookmark2 "bookmark1, bookmark2"
    "bookmark2"}? Maybe, I didn't understand you well, may be you have to
    nest a second IF-field.
    (Maybe, the COMPARE field will help you.)

    --
    Cheers
    Lisa [MS MVP Word]
     
    Lisa Wilke-Thissen, Jul 30, 2012
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Dave
    Replies:
    1
    Views:
    108
  2. Doc
    Replies:
    1
    Views:
    102
    Suzanne S. Barnhill
    Nov 8, 2004
  3. Replies:
    0
    Views:
    320
  4. Jon Coulson

    How to wrap text from cell to cell in a table.

    Jon Coulson, Aug 5, 2005, in forum: Word Tables
    Replies:
    2
    Views:
    152
    jay M
    Aug 8, 2005
  5. Lorraine
    Replies:
    5
    Views:
    177
    Doug Robbins - Word MVP
    Mar 30, 2006
  6. Sinvicta

    Macro for aligning on plus/minus?

    Sinvicta, Sep 5, 2006, in forum: Word Tables
    Replies:
    2
    Views:
    276
    Jezebel
    Sep 6, 2006
  7. Fred
    Replies:
    5
    Views:
    140
  8. Dean

    shift plus hyphen keys

    Dean, Jul 16, 2009, in forum: Word Tables
    Replies:
    2
    Views:
    189
    Suzanne S. Barnhill
    Aug 6, 2009
Loading...