Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Menus and Toolbars / September 2004

Tip: Looking for answers? Try searching our database.

Word Calculations Formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Justin - 16 Sep 2004 13:36 GMT
Hello,

I have created a check request form and would like to add
a calculations formula. If this is possible, could you
please share with me the direction I should focus on.

Thanks,

Justin
Greg - 16 Sep 2004 15:15 GMT
Justin,

Do you mean a protect form using formfields?

Here is an example.  Open a new blank document. View>Tool
Bars>Forms

Insert 3 formfields
Double click the first formfield and select Number as the
type and check calculate on exit
Do the same with the second formfield
Double click the third formfield and select caculation as
the type.  In the expression field enter =Text1+Text2
Protect the form and give it a try ;-)

The variables Text1 and Text2 are the bookmark names of
the first two text formfields in the document.  You can
change these by double clicking the field and entering
your custom bookmark name.

If you are not using a protected form you will need to
somehow identify the reference location of the variables.  
You can do this (but not recommended) as a bookmark in
free text.  Another way is a table cell reference.

Say you bookmark two variables a and b.  You then insert a
formula field {=({a}+{b})} where  { } pairs are entered
with CTRL+F9.  Unlike the formfield method above, these
type fields will not update automatically.  You can right
click the field and manually update individual fields,
CTRL+a and then F9 to update all fields, or it Update
fields is selected in print options you can update at
print or toggle in and out of print preview to update
fields.

The table methd uses cell references.  Enter your varibles
in cell A1 and B1 (thats row 1, column A and B).  In C1,
enter the field code {=(a1+b1)}.

Type =formula in Word help for more on using forumla
fields.
There is
>-----Original Message-----
>Hello,
[quoted text clipped - 7 lines]
>Justin
>.
Justin - 17 Sep 2004 16:35 GMT
Hello,

I have tried to add the suggested formula and I get an
error message "Undefined bookmark text1 .

Prehaps let me explain self a litter better. I have
created a table in Word and designed it into a check
request form. I have 15 columns and rows and want to total
them i.e.,

Descriptoion                 Account         Total
Telephone Service          xxxxxxxxxxx       60.00

Water Bill                 xxxxxxxxxxx       90.00

Light bill                 xxxxxxxxxxx      100.00

                                    Total: $215.00
                                                 
I would like for the total to be calculate automatically.

Thanks for your assistance.

Justin
----Original Message-----
>Justin,
>
[quoted text clipped - 51 lines]
>>
>.
Greg Maxey - 17 Sep 2004 20:08 GMT
Justin,

Standard formula fields in Word to not update (or total automatically).  You
will need to use a protected form with your variable fields set to
"calculate on exit."  You enter formula fields and protect the form using
the Form Toolbar.

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> Hello,
>
[quoted text clipped - 80 lines]
>>>
>> .
macropod - 18 Sep 2004 11:48 GMT
Hi Justin,

To see how you can use formulae in Word, download the document at:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=365442
(url all one line)

Cheers

> Hello,
>
[quoted text clipped - 5 lines]
>
> Justin
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.