98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Office general help » Word
Word
Resolved · Medium Priority · Version 2008 (Mac)
Caroline has attended:
Multiple applications course
Word
How do I formulate calculations in forms.
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Microsoft Office tip:Copying From WebsitesIf you find some interesting text on a website that you wish to use and adapt in your wordprocessor or other package, highlight and copy in the normal way first. |