A CHECKBOX is a visible element which returns a TRUE if checked and FALSE if the checkbox is unchecked.
Checkbox is very useful in many situations such as to manage a TO DO LIST, ATTENDANCE , A CHECKLIST or any situation where we have just two values like a BINARY SYSTEM.
But we have a directly usable option of CHECKBOX in the EXCEL.
A CHECKBOX IS AN ELEMENT WHICH CAN BE USED IN THE SITUATIONS WHERE WE HAVE TWO CHOICES ONLY – INCLUSION AND EXCLUSION. BY DEFAULT, CHECKBOX RETURNS A TRUE IF CHECKED AND FALSE IF UNCHECKED.
In this we’ll learn the ways to insert and use a check box in EXCEL.
A checkbox can be used in the following situations :
The picture above shows a demonstration of the use of CHECKBOX in EXCEL.
It is just a representation but we can extract the analytical data from the table too. In the examples we’ll explore more possibilities from the checkboxes.
The CHECKBOX option is available under the DEVELOPER TAB. The DEVELOPER TAB is not visible by default , so it is important to learn the way to make it visible in your Excel .
CLICK HERE TO LEARN THE PROCESS OF MAKING THE DEVELOPER TAB VISIBLE IN YOUR EXCEL.
After the DEVELOPER TAB is VISIBLE.
Go to DEVELOPER TAB and click INSERT drop down and choose CHECKBOX under the CONTROLS SECTION.
The following picture shows the controls.
STEPS TO INSERT A CHECKBOX IN EXCEL :
This was the procedure to insert a checkbox in EXCEL which was quite simple.
Let us now take an example to learn the use of Check box and its possibilities.
We control a checkbox in Excel by linking it to a cell.
FOLLOW THE STEPS TO LINK THE CHECKBOX TO A CELL.
Carefully RIGHT CLICK the check box.[ THE TEXT OF THE CHECKBOX TO BE PRECISE ].
The following picture shows the scenario.
THE LINKED CELL STORES THE STATUS OF THE CHECKBOX.`
As we click EDIT TEXT, the caption or text will become editable.
Edit the caption as per desire.
A company has floated a contract and applications have been received.
There are 10 criteria in total and the applicants qualifying more than 50% criteria , will have their proposals accepted.
We have created a form containing the checklist of 10 criteria.
We’ll find out the total number of checked CHECK BOXES and compare if the number of checked boxes is more than 50% i.e. 5.
If the number of checked boxes is greater than 5, the proposal will be accepted otherwise rejected.
The following picture shows the scenario
FOLLOW THE STEPS TO CHECK IF THE PROPOSAL IS ACCEPTED OR REJECTED
Let us try to understand the formula used.
We used the formula as
The theoretical explanation of the formula is
IF , NUMBER OF COUNTS OF TRUE [i.e. checked CHECK BOXES ] is greater than 5 i.e. 6 or more , the formula will return ACCEPTED otherwise REJECTED.
IF function is the outermost function.
COUNTIF function has the first argument as H10:H19 which contains the range of the data. i.e. Check boxes.
The second argument of the COUNTIF function is the criteria, we entered TRUE in this which means , it’ll count the TRUE i.e. checked boxes only.
The result will be number of selected Checkboxes.
The second argument of the IF FUNCTION is ACCEPTED, which will be returned if number of selected CHECKBOXES is greater than 5 otherwise REJECTED will be returned.
In this article, we learnt about the way to INSERT CHECKBOXES in EXCEL, how to use a checkbox in EXCEL, how to link a cell to Checkbox in excel and how to edit the caption of the checkbox.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE