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