Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

I want to multiply and add automatically in a form field i..

 
   Windows Help (Home) -> Microsoft Word RSS
Next:  Creating Multiple Record  
Author Message
KobusR

External


Since: Jan 6, 2009
Posts: 2



(Msg. 1) Posted: Tue Jan 06, 2009 2:15 am
Post subject: I want to multiply and add automatically in a form field in word
Archived from groups: microsoft>public>word>docmanagement (more info?)

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

 >> Stay informed about: I want to multiply and add automatically in a form field i.. 
Back to top
Login to vote
Graham Mayor

External


Since: Nov 25, 2008
Posts: 134



(Msg. 2) Posted: Tue Jan 06, 2009 6:25 am
Post subject: Re: I want to multiply and add automatically in a form field in word
Archived from groups: per prev. post (more info?)

Multiply the amount by what?

 >> Stay informed about: I want to multiply and add automatically in a form field i.. 
Back to top
Login to vote
macropod

External


Since: Nov 26, 2008
Posts: 19



(Msg. 3) Posted: Tue Jan 06, 2009 6:25 am
Post subject: Re: I want to multiply and add automatically in a form field in word
Archived from groups: per prev. post (more info?)

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.
 >> Stay informed about: I want to multiply and add automatically in a form field i.. 
Back to top
Login to vote
KobusR

External


Since: Jan 6, 2009
Posts: 2



(Msg. 4) Posted: Tue Jan 06, 2009 6:25 am
Post subject: Re: I want to multiply and add automatically in a form field in wo
Archived from groups: per prev. post (more info?)

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.

"Graham Mayor" wrote:

> Multiply the amount by what?
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site [URL="http://www.gmayor.com"]www.gmayor.com[/URL]
> Word MVP web site [URL="http://word.mvps.org"]http://word.mvps.org[/URL]
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> KobusR wrote:
> > 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
>
>
>
 >> Stay informed about: I want to multiply and add automatically in a form field i.. 
Back to top
Login to vote
Graham Mayor

External


Since: Nov 25, 2008
Posts: 134



(Msg. 5) Posted: Tue Jan 06, 2009 11:25 am
Post subject: Re: I want to multiply and add automatically in a form field in wo
Archived from groups: per prev. post (more info?)

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
 >> Stay informed about: I want to multiply and add automatically in a form field i.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Delete if form field is not defined - I currently have a text form field that is conditional where when you type "OH" or "OHIO" and that state information appears elsewhere in the form. If the field is left blank, it clears the state information. Is there a way that if...

Text form field in footer - Hi, I have a simple questionnaire in a word doc and I've used text form fields so that when the document is protected the user can only complete the right bits and cannot amend the questions. When the user types in their name I would like this to be....

Field Code for Form Fields? - Are there field codes for accessing the contents of form fields, within the same document, by title or tag? (Word 2007)

Multiply in Word 2007 Table - Is it possible to calculate other than Sum? In my table I'd like to be able to multiply one cell with another. Does it work like Excel? Do rows/columns have numbers and letters? In one cell is a cost (i.e., 0.332) and the next cell is the qty (i.e....

automatically inserts words- like company name - - Not auto text, not auto correct...but, I want to insert words on to a list and when I start typing my company name - Eq - that EquaGen appears. Or Miss - and Mississippi. or Je and Jepson appears. In the autocorrect, you have to put the incorrect..
   Windows Help (Home) -> Microsoft Word All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]