? how to Assign a bookmark to a formula in Word

Posted on 2014-08-20
Last Modified: 2014-08-21
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}

Question by:mgmhicks
    LVL 47

    Expert Comment


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

    LVL 76

    Accepted Solution

    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 } }

    Author Closing Comment

    Thanks that worked, didn't know I had to select merge field then add bookmark.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    Outlook Free & Paid Tools
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now