Formula plus text in a cell question

[enigmaes]

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

[Stefan Blom]

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

Post by enigmaes
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

[Lisa Wilke-Thissen]

Hi,

[Word version?]

Post by enigmaes
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.

Post by enigmaes
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.

Post by enigmaes
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.)