Checkbox to calculate credit card surcharge

[Tanner]

Hi all,

I have a word document with a table. I currently have a setup where I sum
cells B2:B16. I would like to add a checkbox somewhere on the document that
would add 3% to the total of B2:B16. So if the checkbox is true add 3% to the
sum, if false leave sum alone.

How would I go about doing that. I want the sum function to work but when I
check the checkbox I want the sum function to add 3%.

Any help would be greatly appreciated.

Tanner

 

[macropod]

Hi Tanner,

For the check box approach to work, you'd need to use a checkbox formfield and protect the document for forms. That would
necessitate other changes to your document also. For example, unless your table (but not the checkbox) is in an unprotected part of
the document, you won't be able to update it as you do now - you'll have to put formfields in each of the cells where you want data
entry to occur.

The other issue with checkboxes is that you can't do anything with their 'state' unless you add a macro to update the document. You
may find that a dropdown formfield would work better. A dropdown formfield would allow the user to select any one of a preset series
of surcharges and, by setting the formfield's properties to 'calculate on exit, the required adjustments to the values could occur
without the need for a macro.

Cheers