[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 614
  • Last Modified:

? how to Assign a bookmark to a formula in Word

I have a couple of merge fields in a document, and I need to use them to create a formula field that gives me a certain result.  Then I want to use that result in another formula.

So how can I create a bookmark called RatePerDay that holds the value of a formula like {resident_current_rate / 31}.  I need this result in a bookmark so I can use for a formula like this.  {Resident_Rent_Days * Bookmark}

thanks
0
mgmhicks
Asked:
mgmhicks
1 Solution
 
Rgonzo1971Commented:
Hi,

You can use the SET Field Instruction to create a bookmark and then use it with the REF Field instruction

http://office.microsoft.com/en-us/word-help/field-codes-set-field-HP010077970.aspx

Regards
0
 
GrahamSkanCommented:
You should be able to insert the bookmark manually in the usual way. You will have to select the whole of the formula field - the REF field will only pick up what is in the bookmark.

With field codes (Alt+F9) and bookmarks (Options>Advanced>Show document content > Show bookmarks) visible it should look something like this:
[{ = { MERGEFIELD RatePerDay } / 31}]

and the location where the result is used would be like this.
{ = { MERGEFIELD Resident_Rent_Days } * {REF RatePerDay } }
0
 
mgmhicksAuthor Commented:
Thanks that worked, didn't know I had to select merge field then add bookmark.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now