Merge fields

Resolved · Medium Priority · Version 2010

Fri 15 Jun 2012, 11:22 Delegate Izabelle said...

Izabelle has attended:
Excel Intermediate course
Excel Advanced course

Merge fields

How do I do a nested merge field with 11 merge fields including an OR command?

The scenario is that there are 11 checkboxes and I need a definition inserted if any one of those are ticked. I understand we can only have 8 nested fields so is this possible?

Thanks

Tue 26 Jun 2012, 14:43 Trainer Simon said...

RE: 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

Attached files...

Nested IF OR.xls

Tue 3 Jul 2012: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Word tip:

Quickly shift a row in a table

Here are some really handy shortcut keys for rearranging rows in a table.

By highlighting a row and using:
- Alt+Shift+Up arrow: you can move a row up in the table.

- Alt+Shift+Down Arrow: you can move a row down in a table.

View all Word hints and tips