What Can You Do with Cell Value If Checkbox Is Checked in Excel: 3 Methods

Method 1 – If Checkbox Is Checked, Set Cell Value

Steps:

  • Go to the Developer tab. If you don’t have it, enable the Developer tab on ribbon from Excel Options.
  • Click on the drop-down arrow of the Insert command and choose the Check Box (Form Controls) option.

if checkbox is checked then cell value in Excel

  • Tthe mouse cursor will change. Drag the cursor in cell C5, and you will get the check box.

  • Keep the mouse cursor on the Checkbox and right-click on your mouse.
  • A context menu list will appear.
  • Choose the Format Control option.

If Checkbox Is Checked Then Set Cell Value

  • A small dialog box called Format Control will appear.
  • In the Control tab, change the option from Unchecked to Checked in the Value section.
  • Set the Cell link. In our case, we chose cell D5.
  • Click OK.

  • The current status of the checkbox will show in that cell.

If Checkbox Is Checked Then Set Cell Value

  • Follow the same procedure for the rest of the entities.

  • Write the following formula in cell E5 using the IF function. This formula will check the checkbox status and show the corresponding result.

=IF(D5,B5,"")

  • Press Enter.

If Checkbox Is Checked Then Set Cell Value

  • Double-click the Fill Handle icon to copy the formula up to cell E14.

  • If you check some boxes, you will see we are getting the final employee list in column E.

If Checkbox Is Checked Then Set Cell Value


Method 2 – If Checkbox Is Checked, Change Cell Value

Steps:

  • Go to the Developer tab. If you don’t have it, enable the Developer tab from Excel Options.
  • Click on the drop-down arrow of the Insert command and choose the Check Box (Form Controls) option.

if checkbox is checked then cell value in Excel

  • The mouse cursor will change. Drag the cursor in cell C5, and you will get the check box.

  • Keep the mouse cursor on the Checkbox and right-click on your mouse.
  • A context menu list will appear.
  • Choose the Format Control option.

If Checkbox Is Checked Then Change Cell Value

  • A small dialog box called Format Control will appear.
  • In the Control tab, change the option from Unchecked to Checked in the Value option
  • Set the Cell link. We chose cell D5.
  • Click OK.

  • The current status of the checkbox will show in that cell.

If Checkbox Is Checked Then Change Cell Value

  • Follow the same procedure for the rest of the entities.

  • Write the salary of the employees in the range of cells E5:E14.

If Checkbox Is Checked Then Change Cell Value

  • Write the following formula in cell F5 using the IF function. This formula will check the checkbox status and show the corresponding result in this cell.

=IF(D5,E5*1.1,E5)

  • Press Enter.

If Checkbox Is Checked Then Change Cell Value

  • Double-click the Fill Handle icon to copy the formula up to cell F14.

  • If you check some boxes, you will see that the bonus has been added for the chosen employees.

If Checkbox Is Checked Then Change Cell Value


Method 3 – If Checkbox Is Checked, Remove Cell Value

Steps:

  • Go to the Developer tab. If you don’t have it, enable the Developer tab from Excel Options.
  • Click the drop-down arrow of the Insert command and choose the Check Box (Form Controls) option.

if checkbox is checked then cell value in Excel

  • Drag the cursor in cell C5, and you will get the check box.
  • Keep the mouse cursor on the checkbox and right-click on your mouse.
  • A context menu list will appear.
  • Choose the Format Control option.

If Checkbox Is Checked Then Remove Cell Value

  • A small dialog box called Format Control will appear.
  • In the Control tab, change the option from Unchecked to Checked in the Value option.
  • Set the Cell Link In our case, we chose cell D5.
  • Click OK.

  • The current status of the checkbox will show in that cell.

If Checkbox Is Checked Then Remove Cell Value

  • Follow the same procedure for the rest of the entities.

  • Write the following formula in cell E5 using the IF function. This formula will check the checkbox status and show the corresponding result.

=IF(D5," ",B5)

  • Press Enter.

If Checkbox Is Checked Then Remove Cell Value

  • Double-click the Fill Handle icon to copy the formula up to cell E14.

  • Check some boxes, and you will see that the values have disappeared from the cells.

If Checkbox Is Checked Then Remove Cell Value


Download Practice Workbook

Download this practice workbook while you are reading this article.


Related Articles


<< Go Back to Excel CheckBox | Form Control in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo