Results 1 to 10 of 10

20080716, 08:18 #1
 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 nonadjacent 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.

20080716, 08:31 #2
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 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...

20080716, 08:45 #3
 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

20080716, 08:56 #4
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 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.

20080716, 09:10 #5
 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.

20080716, 09:16 #6
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 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.

20080716, 09:17 #7
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 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>

20080716, 20:48 #8
 Join Date
 May 2002
 Location
 Canberra, Australian Capital Territory, Australia
 Posts
 5,005
 Thanks
 2
 Thanked 406 Times in 335 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]

20081001, 02:23 #9
 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.

20081001, 03:22 #10
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 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.