Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

word

ResolvedVersion 2008 (Mac)

Caroline has attended:
Multiple applications course

Word

How do I formulate calculations in forms.

Edited on Fri 18 Sep 2009, 15:47

RE: Word

Hi Caroline - thank you for your question and welcome to the forum.

In Word try this:

Turn on the form toolbar (View > toolbars > Forms) then use the ab button to create input fields (eg hours_required; artwork_cost_per_hour; additional_cost)

Next double click on each field created and
set its type to number
rename the bookmark entry to something more descriptive than the default name created by Word)
tick the box to Calculate on exit

( The dropdown field unfortunately only returns text rather than numbers so won’t help as part of a calculated form unless we use some VBA programming)

At the end of the document click where the calculated total should appear and insert a field by going to the Insert menu then select Field. Set the Category to All and from the top of the list choose =Formula then click on the Formula button.

Delete any formula in the box and begin your formula by entering the = symbol.Use the paste bookmark button to help build the formula that will calculate the total e.g.
=(hours_required*artwork_cost_per_hour)+additional_cost+printing_cost+mailing_cost

Use the padlock on the form toolbar to protect the sheet for forms and enter values to test the calculation.

Let me know if you have any questions.


Kind regards,
Andrew

Fri 25 Sep 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Microsoft Office tip:

Full Menu Display (Office 2003-2000)

One of the developments in Microsoft Office is that the Menu system has been optimized. This means that only recently used functions are displayed initially when you SINGLE CLICK on the menu.
There are many ways of getting around this:
1. DOUBLE CLICK on the menu bar, it will automatically expand
2. click on the DOUBLE ARROW you see on the bottom of the menu.
3. Wait for the menu to expand

If you always want to have the menus expanded:
4. On the menu bar, click TOOLS, then CUSTOMISE. Select OPTIONS, then uncheck the

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.42 secs.