Excel tutorials

Checkboxes in Excel are very useful, they are boxes that we can insert into a cell. Then we can check or uncheck them with a simple click.

They have two values:

• A checked box has the value TRUE
• An unchecked box has the value FALSE

Lets make an example:

• Enter some data
• Insert checkboxes
• To insert checkboxes, select the cells where you want them, go to the “Insert” tab – and click on “Checkbox”
• Use a formula to find out if the box is checked or unchecked.

• The column “Assignment complete” has a formula behind it.
• Use the below formula to give a result wheater the box is checked or not
• =IF(H12;”YES”;”NO”)
• If the box is checked, the formula return YES, otherwise NO