Merge fields

Hi Izabelle,

Thank you for your question.

You can add checkboxes via the legacy form tools on the controls group of the Developer tab.

Once the checkboxes have been added, right click over a checkbox and choose Format Control.

Select the 'Mixed' option and then click into the 'Cell Link' box. Now select a cell that will automatically display true or false depending on whether the checkbox is ticked or not. Repeat this procedure for each checkbox.

On the spreadsheet I have attached, I have created an If(OR) formula which will place a value of 1 in the cell if just one of the checkboxes are ticked. My cell links are in column H and these are the cells that are being tested.

I hope it makes sense.

Regards

Simon