Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    239
    Thanks
    4
    Thanked 1 Time in 1 Post

    Formulas (Word 2003)

    I have a DocProperty called FixedDayRate. I have a table with a column for days where I will enter the number of days for a piece of work. In the next column I need the result of the number of days times the FixedDayRate. Is that possible in Word please?

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Formulas (Word 2003)

    Suppose that you have FixedDayRate as a document property with a value of 240, and cell A1 of your table has the text 6.

    Insert the field code { ={ =A1 }*{ DOCPROPERTY FixedDayRate } } into the cell where you want the value to appear. You put in the { } using Control-F9 (don't type the {} from the keyboard).

    Right click on your field codes and select Update Field, you will see the value 1440 appear.

    StuartR

  3. #3
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    239
    Thanks
    4
    Thanked 1 Time in 1 Post

    Re: Formulas (Word 2003)

    Thanks Stuart.

    For the benefit of anyone else looking up this thread, the entry of { } using CTRL F9 applies to all bracket in the formula, not just the first and last.

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    239
    Thanks
    4
    Thanked 1 Time in 1 Post

    Re: Formulas (Word 2003)

    Am I right in thinking that I have to enter the formula manually in each row? Copying and pasting does not seem to work or allow editing to change the cell reference.

  5. #5
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    239
    Thanks
    4
    Thanked 1 Time in 1 Post

    Re: Formulas (Word 2003)

    Got it. Copy and paste the formala. Select Toggle and put the cursor in the value that is shown at that stage. RIght click and select Edit, then you can change the cell referenced.

  6. #6
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Formulas (Word 2003)

    Hi Peter,

    FWIW you can simplify the formula to: {=A1*{DOCPROPERTY FixedDayRate}}

    Also, if you check out my Word Field Maths 'tutorial in <post#=365442>post 365442</post#>, you'll see how you can implement a form of relative cell referencing so that you don't have to edit the formula for each row.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  7. #7
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    UK
    Posts
    239
    Thanks
    4
    Thanked 1 Time in 1 Post

    Re: Formulas (Word 2003)

    I still have plenty of cells to set up so both tips will be useful.

    Many thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •