Using Bookmarks in Word Formulas 1

[david6633]

First off I realise that Word formulas are not the most user friendly thing that MS has come up with but they make life simple.

I have a Word document with several tables in in. I have bookmarked some cells and now I am trying to use the values from the bookmarked cells in calculations in other cells but without any luck.

Has anyone ever managed to get this to work?

According toe the Word help file this should be possible.

I am using Word 2002.

David
Remember: You only know what you know
and - you don't know what you don't know!

 

[xlhelp]

You can use bookmarks in calculations. The only one I have used for summing. For example, if you have bookmarked them as Pr1, Pr2, Pr3 then the formula would be =sum(Pr1,Pr2,P3). Make sure you bookmark the value in the cell and not the cell itself.

 

[david6633]

Thanks.

The bit I had missed was setting the bookmark on the value/formula and not the cell.

David
Remember: You only know what you know
and - you don't know what you don't know!

 

[macropod]

Hi David,

In this case, you don't need to use bookmarks: you can use the cell addresses instead. For example:
{=SUM(A1:A3)}

For more on Word formulae, check out my Word Field Calculations 'tutorial', at:

http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=365442

Cheers

[MS MVP - Word]

 

[david6633]

Hi macropod

I am full conversant with how do the calculations but I am not aware of any method of using cell references when the data is in another table as was my original problem.

David
Remember: You only know what you know
and - you don't know what you don't know!

 

[macropod]

Hi David,

You can do that by bookmarking the source table, and including the bookmark reference in the formula, along with the cell references. This is generally more reliable than trying to work with individually bookmarked cell values.

The method is fully explained in the document referred to in my previous post.

Cheers

[MS MVP - Word]