• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Checkbox question

P

Pofski

Member
Hello everybody,


I was wondering if there was a way to combine checkboxes.
Lets say that you have a list of 10 checkboxes, underneath each other.
Each individually is linked to a cell for a TRUE, FALSE statement.

Would it be possible to make a list of 5 check boxes next to it, that would would work on the first list, so that each checkbox of the second list would change 2 of the first list.

For example, if you check the first box on the second list, the first two on the first list would say true.
Second checkbox on second list would put true on box nr 3 and 4 on first list.

All this, but in a way that you can still use the first list for individual selections.

Hope this makes some sense.


Sincerely
 
Hi,
I would link each list of checkboxes to there own column (ie: 5 checkboxes for list ONE in A1:A5; 5 checkboxes for list TWO in B1:B5). Then I could use any logic I need (IF, AND, OR, Bolian, etc) to a new column.
Does this make sense to you?
 
Hi Pofski ,

Anything is possible ; can you specify what use will be made of these checkboxes , since the kind of logical connection between the boxes that you want , can be easily done at the final stage , when you use the linked cells themselves.

Suppose the first 10 checkboxes have the linked cells C1 through C10 ; suppose the second list of 5 checkboxes have the linked cells D1 through D5.

In the cells E1 through E10 , you can have formulae such as :

=OR(D1,C1)
=OR(D1,C2)

=OR(D2,C3)
=OR(D2,C4)

=OR(D3,C5)
=OR(D3,C6)

=OR(D4,C7)
=OR(D4,C8)

=OR(D5,C9)
=OR(D5,C10)

Now , in the formulae where you are using the cells C1 through C10 , use the values in E1 through E10.

Narayan
 
You must log in or register to reply here.
Back
Top