Word Field Code calculation

Question

Hi, I have a word form doc that has two check boxes and I want to assign a value if ticked (box 1 ticked would be 5 and box 2 if ticked 15). In a separate field I want to total the result of the check box selection. So the answer could either be 0, 5, 15 or 20. 

What's the easiest way to do this in word as it's driving me potty.

Thanks in advance.

Answer 1

Word field codes cannot perform calculations based on checkbox values. Rather than using checkboxes, you might consider using dropdown formfields with Yes/No answers and their 'calculate on exit' property set in a document will 'filling in forms' protection applied. You could then do the calculation with a formula field coded like:

{={IF{REF Dropdown1}= "Yes" 5 0}+{IF{REF Dropdown1}= "Yes" 15 0} # 0}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required.

Answer 2

Thanks for the quick response. I had spotted the mistype.

By adding the Insert Field Chars to the ribbon, it made adding the code much easier.

Thank you all for your help and assistance.

I can now sleep tonight. :-)

Steve

Answer 3

Compare what you have tried with the example I posted at https://1drv.ms/w/s!AgOi7jMKouNNnFDZ2vDPD1icPsVe

You will need to unprotect it before you can see the field coding. Use option-F9/alt-F9/fn-option-F9/fn-alt-F9, depending on your keyboard preferences, to toggle between "field code" view and field results view.

The other thing that you may need to know is that the result value (0,5,15,20) will not change until you actually click or tab somewhere outside one of the dropdown fields. Just changing the selection from Yes to No or No to Yes isn't enough - that's just the way this type of form works.

There's a typo in Paul's field code as it stands - one of the "Dropdown1"s needs to be "Dropdown2" - but I assume you picked that up.

Answer 4

Thanks for this. I can use a drop down field instead but still can't get it to work.

I've used the Insert field option then use the expression builder to add as above and it gives a syntax error. Tried editing but still no joy. 

There does not seem to be much documentation on this function either.

Where could I be going wrong?