I want to multiply and add automatically in a form field in word

K

KobusR

I want to type an amount in a form field. The next form field must
automatically multiply this amount. The last form field must add field 1 and
field 2's data. This must happen of a form I've designed in Word
 
G

Graham Mayor

Multiply the amount by what?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
M

macropod

Hi KobusR,

You don't need formfields for the calclations - just formula fields. Suppose the formfield into which you insert the number is named
'Text1' and its properties are set to 'calculate on exit'. In that case you can use a formula field coded as:
{=Text1*0.1 \# $,0.00}
to calculate 10% of the formfield's value, and
{=Text1*1.1 \# $,0.00}
to calculate 110% of the formfield's value - which is the same as summing the formfield's value and the 1st calculation's result.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

I advise you not to try to use a formfield to do the calculations the way you've described. When you use the result of a given
formfield's calculation in another formfield, the results in the dependent formfield are unreliable.
 
K

KobusR

Eg. First form field will have an amount in which can varies
1. $ 540.00
2. 2nd form field must multiply this amount by .14 to work out the tax that
would be payable.(In South Africa)
3. Last form field must have the total of 1. + 2.
 
G

Graham Mayor

Assume that the form field is Text1, set the type to number with a dollar
format and check calculate on exit check box

Set the two extra form fields as type Calculated and the calculations in the
field properties are

=Text1 * .14

and

=Text1 * 1.14

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top