Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Jul 2008
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Word Field Calculations (2002 SP3)

    Hello,

    I am trying to calculate two non-adjacent fields in a word table by multiplying them together. My syntax is =sum(text85*text73), these are the bookmark names. It will not calculate but if I put a comma there, it does add the fields. Can you help!!!?

    Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Word Field Calculations (2002 SP3)

    Welcome to Woody's Lounge!

    Try a field that looks like { ={ text85 }*{ text73 } }

    Remember, you should never type the field braces { } yourself, use Ctrl+F9 to create them, or select Insert | Field...

  3. #3
    New Lounger
    Join Date
    Jul 2008
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Word Field Calculations (2002 SP3)

    Hi,

    So under the expression field on the text form field option, is that where I would put the formula? Pressing Ctrl+F9 does not work on that field.



    Thanks,

    Cynthia

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Word Field Calculations (2002 SP3)

    My suggestion was meant as a "normal" field, not a text form field. If you want to use a calculated text form field, set the expression to

    =text85*text73

    and make sure that the "Calculate on exit" check box has been ticked in the properties of both text85 and text73.

  5. #5
    New Lounger
    Join Date
    Jul 2008
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Word Field Calculations (2002 SP3)

    Thanks,

    That worked! I have one more questions, how would I create a formula to calculate the sales tax?

    P.S. I am new to this website and I think it is great, I will definitely pass it along.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Word Field Calculations (2002 SP3)

    If you want to use a calculated text form field: set the expression to

    =text99*6.5%

    if the amount over which you want to calculate sales tax is in text99, and if the sales tax is 6.5%.

    If you want to use a "normal" field: make it look like { ={ text99 }*6.5% } with the same assumptions as above.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Word Field Calculations (2002 SP3)

    Thanks for the compliment! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

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

    Re: MS Word Field Calculations (2002 SP3)

    Hi Cynthia,

    To see the kinds of calculations you can do with Word's 'normal' formula fields, check out my Word Field Maths 'tutorial' in <post#=365442>post 365442</post#>. These calculations can all take their parameters from formfields. Plus, using a formula field avoids some of the pitfalls you can get into when using a formfield to do calculations.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  9. #9
    Star Lounger
    Join Date
    Feb 2003
    Location
    Hillsdale, New Jersey, USA
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MS Word Field Calculations (2002 SP3)

    Should the calculated field have "Calculate on Exit" checked, Hans? I tried it both ways and it doesn't seem to make any difference. BTW, I add may thanks for the work you do on this forum.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MS Word Field Calculations (2002 SP3)

    The field that contains the formula doesn't need to have "Calculate on Exit" ticked, only the form fields that contribute to the result of the formula.

    When the user enters or edits a value in one of those form fields, the formula will be recalculated after the user tabs or clicks out of the form field, not before.

Posting Permissions

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