Thread: MS Word Field Calculations (2002 SP3)

1. 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. 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. 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. 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. 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. 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. 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. 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.

9. 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. 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
•