Using CheckBoxes in a Calculation

[Miricleman]

Hi,

I am trying to figure out how to incorporate a checkbox in a form calculation.



As in the Picture I have uploaded I am trying to get a calculation legacy form to multiple the number of entries by the events selected in the checkboxes by the cost per event of $10.

I put this formula in a calculation field and also a field formula but it does not seem to work.
=IEtwodogscooter*(if(check1=true,10,0)+if(check2=t rue,10,0)+if(check3=true,10,0))

Is this something that is able to be done with checkboxes or is there another workaround for this type of problem?

[Miricleman]

Please someone put me out of my Misery...... Is this at all Possible or is there another solution???

[macropod]

To perform calculations using any kind of checkbox requires a macro. A field cannot do calculations based on checkbox states. You could, however, replace the checkboxes with dropdown for fields containing yes/no responses and use fields to calculate from those.

[Miricleman]

Hi Macropod,

Yes i did try using a drop down box for different selection. I could not get it to work. If you know how to get this to work can you please advise?

Thanks

[macropod]

The required formula field (not formfield) would be encoded along the lines of:
{=twodogscooter*{={IF{REF Dropdown1}= "Y*" 10 0}+{IF{REF Dropdown2}= "Y*" 10 0}+{IF{REF Dropdown3}= "Y*" 10 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 construction are all required.