Excel Tips: How to insert Check Box in Excel Sheets?

 Problem: How to insert a check box from developer tab and to assign to another cell to use the result for further conditioning?

Solution: To assign a tick mark from a checkbox to another cell and use the result for further conditioning in Excel, you can link the checkbox to a specific cell. Here’s how you can do it:

1. Insert the Checkboxes:

   • Go to the Developer tab.
   • Click on Insert and choose the checkbox from the Form Controls section.
   • Draw the checkbox on your sheet. Repeat this step for additional checkboxes as needed.

2. Link the Checkboxes to Cells:

   • Right-click on a checkbox and select Format Control.
   • In the Format Control dialog box, go to the Control tab.
   • In the Cell link field, enter the reference of the cell where you want the checkbox result to be stored (e.g., J2).
   • Click OK.
   • Repeat these steps for each checkbox, linking them to different cells as required.

3. Use the Linked Cell for Conditioning:

   • When a checkbox is checked, the linked cell will show TRUE. When unchecked, it will show FALSE.
   • You can now use these linked cells in your formulas. For example, if you linked a checkbox to cell J2, you could use a formula like:

     excel
     =IF(J2=TRUE, "Task Completed", "Task Pending")
     

   • This formula will display "Task Completed" if the checkbox is checked and "Task Pending" if it is not.

Example:

• Suppose you have checkboxes linked to cells J2, J3, and J4.
• You can create a summary cell that shows a message based on all checkboxes, like:

  excel
  =IF(AND(J2=TRUE, J3=TRUE, J4=TRUE), "All tasks are completed", "Some tasks are pending")
  

By linking the checkboxes to specific cells and using these cells in your formulas, you can create conditional logic based on the state of the checkboxes.